SSIS Script Task - Issue with getting remote file info

Advertisement

fongrj
Joined:
Posts:
2
Location:
Portland - Oregon - USA

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).

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
40,476
Location:
Prague, Czechia

Re: SSIS Script Task - Issue with getting remote file info

Do I understand right that you want to get an XML log, but you are getting a session log instead? XML logging is supported since 4.2.x only.

Reply with quote

fongrj
Joined:
Posts:
2
Location:
Portland - Oregon - USA

Re: SSIS Script Task - Issue with getting remote file info

martin wrote:

Do I understand right that you want to get an XML log, but you are getting a session log instead? XML logging is supported since 4.2.x only.

Got it to work by updating to 4.2.7
Thanks.

Reply with quote

Advertisement

You can post new topics in this forum