February 27, 2012 at 8:43 am
Hi ,
I have to transfer file from sftp site to my local server on E:\ecol\ . I have used 3rd party tool WinSCP and created .txt file.
My .txt file is working . I took execute process task to execute .txt file but it is throwing an error invalid access to memory.
Please correct me if I have given incorrect path or arguments .
script for .txt file :
option batch on
option confirm off
open sftp://user:password@IPAddress:Port
cd ER_Reports\OHE\
option transfer ascii
get AIO_Activity-en-us.csv E:\ecol\
close
exit
path for WinSCP : C:\Program files(x86)\WinSCP\WinSCP.com
path for .txt file : C:\Users\Jpatel\Batch files\ecollege.txt
I am not sure about working directory.
Configuration of Execute process task :
Requirefullname : True
Executable : C:\Program files(x86)\WinSCP\WinSCP.com
Arguments : -script=C:\Users\Jpatel\Batch files\ecollege.txt
Working Directory : C:\Program files(x86)\WinSCP
StandardInputVariable :
StandardOutputVariable:
StandardErrorVariable:
FailTaskIfReturnCodeIsNotSuccessValue : True
SuccessValue : 0
TimeOutValue: 0
WindowStyle : Normal Please suggest me the solution where I have given incorrect information in the configuration.
Thanks,
Jasmini
February 27, 2012 at 11:53 pm
Is it possible to post the entire error message?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2013 at 2:32 am
Hi Jasmini,
Did you ever get this working? And if so, were you able to get the output from winscp into a variable defined in the StandardOutputVariable property? That's the bit that I am struggling with right now.
thanks
Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
May 9, 2013 at 4:38 pm
Hello Jamie, What output from WinSCP are you trying to capture in the output variable? I am just curious and may be able to help.
May 9, 2013 at 11:24 pm
julie.d.mcguire (5/9/2013)
Hello Jamie, What output from WinSCP are you trying to capture in the output variable? I am just curious and may be able to help.
Hi Julie,
No worries. I've managed to get it working now. Thanks for the reply anyhow.
regards
Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
May 10, 2013 at 7:29 am
hi julie
how did you fix it??
May 10, 2013 at 7:41 am
Leep 63464 (5/10/2013)
hi juliehow did you fix it??
I think 'Jamie' was the name you were looking for 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply