guide_ssis » Revisions »

Differences

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

2011-05-24		2011-07-31
session_configuration#stored (martin)		scriptcommand_* (martin)
	Line 22:		Line 22:

	In the script you need at least to:		In the script you need at least to:
-	* Replace ''mysession'' argument to ''[[script_commands#open\|open]]'' command with specification of SFTP connection in form ''%%sftp://username:password@hostname%%'' or use name of [[session_configuration#stored\|stored session]].	+	* Replace ''mysession'' argument to ''[[scriptcommand_open\|open]]'' command with specification of SFTP connection in form ''%%sftp://username:password@hostname%%'' or use name of [[session_configuration#stored\|stored session]].
-	* Replace hostkey fingerprint after ''hostkey'' switch of open ''[[script_commands#open\|open]]'' command with actual fingerprint of your [[ssh#verifying_the_host_key\|SFTP/SSH server hostkey]];((Note that depending on encryption method, the hostkey may have different format than shown in the example))	+	* Replace hostkey fingerprint after ''hostkey'' switch of open ''[[scriptcommand_open\|open]]'' command with actual fingerprint of your [[ssh#verifying_the_host_key\|SFTP/SSH server hostkey]];((Note that depending on encryption method, the hostkey may have different format than shown in the example))
-	* Replace paths after ''[[script_commands#get\|get]]'' command with actual paths to remote file to download from and local directory to download to.	+	* Replace paths after ''[[scriptcommand_get\|get]]'' command with actual paths to remote file to download from and local directory to download to.

	Save the script into file accessible from SSIS.		Save the script into file accessible from SSIS.