Topic "avoid error in ssis package using winscpcommand in sql server agent job"

Author Message
balukumar
[View user's profile]

Joined: 2015-12-16
Posts: 1
Hi I have doubt in ssis using winscp commands on excuteprocess task

I need download/move .zip file from remote server to local server machine. Here I follow few steps:

step1:I install winscp software in local server .
step2: I configure winscp settings with hostnameand username and pwd it working fine.

step3: I tried to implement ssis package using executeprocess task
there I given like below seetings in execute process task
executable:

C:\Program Files (x86)\WinSCP\WinSCP.exe

Arguments:
/command "open ""sftp://uesrname:pwdhostname""" "get ""remoterservrpath"" localpath" "exit"
after that I ran execute process task.then file is moved from remoteserver to localserver path location then imedentaily package failed with below error message


in bids environment package working fine. same package I tried to run on sql server agenct job that time
I got error like below
[Execute Process Task] Error: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "WinSCP /command "open ""
sftp://usernamepwdhostname""" "get ""test.zip""
C:\Users\test\Desktop\Test\test.zip" "exit"" at "",
The process exit code was "1" while the expected was "0".
here usernamepwdhostname I did not share orignal.I mention similay format. zip file is moved from remote to local server location.its fine.but I am getting package error after move the .zip file
in the job I foll steps like below
steps: in the steps table: i given step: test
steptype:sql server integration package
server:test
Package: testpackage
select 32 bit runtime

please tell me how to avoid this error in ssis package using sql server agent job
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
Start here:
http://winscp.net/eng/docs/troubleshooting#scripting

If you cannot help yourself, we need to see a session log.
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