Execute Process WinSCP on another server
Got the script working inside of an SSIS package loop - where it takes each file and dynamically builds the script then calls the WinSCP.com to do a command execute the script.
This works fine when the WinSCP and the files to upload reside on the same server the package is running on.
But our DBA is freaking out and he wants WinSCP and the generated files to sftp on another server. I've made a mapped drive and use that to access the other server and I can gnerate and save the new files to the other server. I then try to process each file using an Execute Process Task with the Process Executable point to the instance of WinSCP on the mapped drive by listing it as Y:\Program Files\WinSCP\WinSCP.com
When the package gets to the Process Execute task it blows up with
"Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "Y:\Program Files\WinSCP\WinSCP.com" "" at "", The process exit code was "1" while the expected was "0".
Task failed: Execute Process Task"
Can a SSIS Package have a Execute Process Task to run WinSCP.com on another server??
Script looks like this:
"option batch on
option confirm off
open CLM
cd /upload
put TEST_PRODUCT_GROUPS_20110325145227.txt
exit
"
CLM is a saved session with default local directory and / for the remote directory
But if I've shelling out to "Y:\Program Files\WinSCP\WinSCP.com" do i need to list the local directory as what it is on the remote FTP server? I see DOS window tries to open on the SSIS Package server rather than on the other server?
This works fine when the WinSCP and the files to upload reside on the same server the package is running on.
But our DBA is freaking out and he wants WinSCP and the generated files to sftp on another server. I've made a mapped drive and use that to access the other server and I can gnerate and save the new files to the other server. I then try to process each file using an Execute Process Task with the Process Executable point to the instance of WinSCP on the mapped drive by listing it as Y:\Program Files\WinSCP\WinSCP.com
When the package gets to the Process Execute task it blows up with
"Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "Y:\Program Files\WinSCP\WinSCP.com" "" at "", The process exit code was "1" while the expected was "0".
Task failed: Execute Process Task"
Can a SSIS Package have a Execute Process Task to run WinSCP.com on another server??
Script looks like this:
"option batch on
option confirm off
open CLM
cd /upload
put TEST_PRODUCT_GROUPS_20110325145227.txt
exit
"
CLM is a saved session with default local directory and / for the remote directory
But if I've shelling out to "Y:\Program Files\WinSCP\WinSCP.com" do i need to list the local directory as what it is on the remote FTP server? I see DOS window tries to open on the SSIS Package server rather than on the other server?
