Re: SSIS WinSCP integration using Ppk without Password
Nik, is the above a question or an example solution?
-script=D:\script.txt -parameter c:\database\templete.xls
and in the script
option batch off
option confirm off
open XXXXXXXXXXXX
put %1% /database/
exit
will the above code work?
I do not think this makes any difference.
Change your arguments from using /script or /key to -script and -key
When I execute the task, I receive an [Execute Process Task]Progress: Operation Complete - 100 percent complete. However it did not transfer (get) the zip file from the FTP server. What am I doing wrong?
I have the following script that I wrote to a text file called download.txt:
option batch on
# Disable overwrite confirmations
option confirm off
# Do the work
get file*.zip c:\Folder
# Close and exit
close
exit
I am using an SSIS Execute Process Task with the following settings:
RequireFullFileName: True
Executable: C:\Program Files\WinSCP\WinSCP.exe
Arguments: user@ftp.server.com:2222 /privatekey="c:\Folder\PKey.ppk" /script="c:\Folder\download.txt"
WorkingDirectory: c:\Folder
The rest of the settings are default.
When I execute the task, I receive an [Execute Process Task]Progress: Operation Complete - 100 percent complete. However it did not transfer (get) the zip file from the FTP server. What am I doing wrong?
Hi, I can't seem to figure out the command line syntax to run this software with SSIS execute process task.
Here is what I have so far.
I call the WinScp.exe
I pass this line in as my argument
user@mysite.com /privatekey/ "\\test\f$\Import\scp Keys\OSF priv key.ppk"/script="\\sqltest\e$\SSIStest\Export\sftpscript.txt"
it times out everytime?
Hi, I can't seem to figure out the command line syntax to run this software with SSIS execute process task.
Here is what I have so far.
I call the WinScp.exe
I pass this line in as my argument
user@mysite.com /privatekey/ "\\test\f$\Import\scp Keys\OSF priv key.ppk"/script="\\test\a$\SSIStest\Export\sftpscript.txt"
it times out everytime?