guide_ssis » Revisions »
Differences
This shows you the differences between the selected revisions of the page.
2015-12-17 | 2015-12-23 | ||
removing uses of option batch and confirm not needed since 5.6 with release of the next major branch 5.8 (martin) | 5.8 Script or .NET assembly code template can be generated in GUI. (martin) | ||
Line 31: | Line 31: | ||
In SSIS, add new //Execute Process// task to control flow of your package. In the //Execute Process Task Editor//: | In SSIS, 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//; | ||
- | * In //Arguments// specify ''/script=<pathtoyourscript>''; | + | * In //Arguments// specify ''/script=<pathtoyourscript>'' (Alternatively you can specify all commands here using ''/command'' switch, as used [[ui_generateurl|the command-line template]] that WinSCP can generate for you); |
* You may want to set //WorkingDirectory// to path, where you want to download files to/upload files from, if you do not use absolute paths in your script. | * You may want to set //WorkingDirectory// to path, where you want to download files to/upload files from, if you do not use absolute paths in your script. | ||