guide_ssis » Revisions »

Differences

This shows you the differences between the selected revisions of the page.

guide_ssis 2019-05-22		guide_ssis 2022-08-12 (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//;