Execute Process Task using WinSCP

  • 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

  • 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

  • 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

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

  • 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

  • hi julie

    how did you fix it??

  • Leep 63464 (5/10/2013)


    hi julie

    how did you fix it??

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply