SSIS Script Task - Issue with getting remote file info
Need assistance getting functionality on WinSCP within SSIS. I'm passing 2 arguments:
1- Is the log file which I was expecting the second argument provide listed files
2- Opens session and list of specific file info on remote server
Have the current settings on [Execute Process Task]
RequireFullName: True
Executable: C:\Program Files\WinSCP\WinSCP.com
Arguements:
/log="C:\TEST\FileProcessing\Files\Type5\Download\transfer_log.xml"
/script="C:\TEST\FileProcessing\WinSCP_Scripts\sFTP_ProvCon_Type_5_ls_PROC.txt"
FailTaskIfReturnCodeIsNotSuccessValue: True
SuccessValue: 0
TimeOut: 0
WindowStyle: Normal
I get .xml file - but it contains connection info (ie. session name, host name, username, tunnel...). My version locally which I've been able to get working is V4.2.7 (Build 758).
However the prod server is using the following version v4.1.8 (Build 415).
1- Is the log file which I was expecting the second argument provide listed files
2- Opens session and list of specific file info on remote server
Have the current settings on [Execute Process Task]
RequireFullName: True
Executable: C:\Program Files\WinSCP\WinSCP.com
Arguements:
/log="C:\TEST\FileProcessing\Files\Type5\Download\transfer_log.xml"
/script="C:\TEST\FileProcessing\WinSCP_Scripts\sFTP_ProvCon_Type_5_ls_PROC.txt"
FailTaskIfReturnCodeIsNotSuccessValue: True
SuccessValue: 0
TimeOut: 0
WindowStyle: Normal
I get .xml file - but it contains connection info (ie. session name, host name, username, tunnel...). My version locally which I've been able to get working is V4.2.7 (Build 758).
However the prod server is using the following version v4.1.8 (Build 415).