Topic "SSIS Script Task - Issue with getting remote file info"

Author Message
fongrj
[View user's profile]

Joined: 2012-04-04
Posts: 2
Location: Portland - Oregon - USA
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).
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
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.
_________________
Martin Prikryl
fongrj
[View user's profile]

Joined: 2012-04-04
Posts: 2
Location: Portland - Oregon - USA
prikryl 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.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License