guide_ssis » Revisions »

Differences

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

2017-01-11		2018-03-21
explicit anchor use (martin)		SSIS is managed using SSDT now (martin)
	Line 1:		Line 1:
-	====== SFTP Task for SSIS ======	+	====== SFTP Task for SSIS/SSDT ======
	//This guide contains description of creating SFTP((SFTP is also incorrectly known as Secure FTP.)) file transfer task for SSIS using WinSCP [[scripting]]. The preferred approach is to use the [[library_ssis\|WinSCP .NET assembly from SSIS script task .NET code]].//		//This guide contains description of creating SFTP((SFTP is also incorrectly known as Secure FTP.)) file transfer task for SSIS using WinSCP [[scripting]]. The preferred approach is to use the [[library_ssis\|WinSCP .NET assembly from SSIS script task .NET code]].//

	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]].	+	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.

	<code winscp>		<code winscp>
	Line 28:		Line 28:
	Save the script into file accessible from SSIS.		Save the script into file accessible from SSIS.

-	===== SSIS task =====	+	===== SSIS/SSDT task =====
-	In SSIS, 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//;
	* In //Arguments// specify ''[[commandline#scripting\|/script=<pathtoyourscript>]]'' (Alternatively you can specify all commands here using ''[[commandline#scripting\|/command]]'' switch, as used [[ui_generateurl\|the command-line template]] that WinSCP can generate for you);		* In //Arguments// specify ''[[commandline#scripting\|/script=<pathtoyourscript>]]'' (Alternatively you can specify all commands here using ''[[commandline#scripting\|/command]]'' switch, as used [[ui_generateurl\|the command-line template]] that WinSCP can generate for you);