guide_ssis » Revisions »
Differences
This shows you the differences between the selected revisions of the page.
| guide_ssis 2019-05-22 | guide_ssis 2025-09-22 (current) | ||
| Line 13: | Line 13: | ||
| Start by creating WinSCP script file to transfer your files. | Start by creating WinSCP script file to transfer your files. | ||
| - | Below you can see a basic script example for downloading file from SFTP server. For details see [[guide_automation|guide to automation]] or [[scripting|detailed documentation of scripting functionality]]. You can also have WinSCP [generate a script template](ui_generateurl#script) for you. | + | Below you can see a basic script example for downloading file from SFTP server. For details see [[guide_automation|guide to automation]] or [[scripting|detailed documentation of scripting functionality]]. You can also have WinSCP [[guide_automation#generating|generate a script template]] for you. |
| <code winscp> | <code winscp> | ||
| - | open mysession -hostkey="ssh-rsa 2048 xxxxxxxxxxx...=" | + | open mysession -hostkey="ssh-rsa 2048 xxxxxxxxxxx..." |
| get /remotepath/data.dat c:\localpath\ | get /remotepath/data.dat c:\localpath\ | ||
| exit | exit | ||
| Line 28: | Line 28: | ||
| Save the script into file accessible from SSIS. | Save the script into file accessible from SSIS. | ||
| - | ===== SSIS/SSDT task ===== | + | ===== [[task]] SSIS/SSDT task ===== |
| In SSIS/SSDT, add new //Execute Process Task// to control flow of your package. In the //Execute Process Task Editor//: | In SSIS/SSDT, add new //Execute Process Task// to control flow of your package. In the //Execute Process Task Editor//: | ||
| * Put path to WinSCP [[executables|executable]] (by default ''C:\Program Files (x86)\WinSCP\WinSCP.exe'') &winpath &win64 into //Executable//; | * Put path to WinSCP [[executables|executable]] (by default ''C:\Program Files (x86)\WinSCP\WinSCP.exe'') &winpath &win64 into //Executable//; | ||
| Line 45: | Line 45: | ||
| ===== Other References ===== | ===== Other References ===== | ||
| - | * [[https://www.codeproject.com/Articles/23740/SFTP-with-SSIS-Packages|SFTP with SSIS Packages]]. | + | * [[https://www.codeproject.com/articles/SFTP-with-SSIS-Packages|SFTP with SSIS Packages]]. |