Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute Process Task using WinSCP Expand / Collapse
Author
Message
Posted Monday, February 27, 2012 8:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:15 PM
Points: 8, Visits: 63
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




Post #1258300
Posted Monday, February 27, 2012 11:53 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 13,636, Visits: 11,508
Is it possible to post the entire error message?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1258638
Posted Monday, April 29, 2013 2:32 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
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
Post #1447402
Posted Thursday, May 9, 2013 4:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:41 PM
Points: 6, Visits: 245
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.
Post #1451372
Posted Thursday, May 9, 2013 11:24 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
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
Post #1451416
Posted Friday, May 10, 2013 7:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:41 PM
Points: 14, Visits: 128
hi julie
how did you fix it??
Post #1451583
Posted Friday, May 10, 2013 7:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 5,316, Visits: 12,346
Leep 63464 (5/10/2013)
hi julie
how did you fix it??


I think 'Jamie' was the name you were looking for



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1451594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse