Post reply

How can i do SFTP using script task?

  • February 2, 2012 at 1:46 am

    #391460

    How can i do SFTP using script task?

  • February 2, 2012 at 2:02 am

    #1441598

    Which SFTP client are you using?

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

  • February 2, 2012 at 2:05 am

    #1441599

    I don't want to use any third party party tool.

    Is it possible?

  • February 2, 2012 at 2:10 am

    #1441601

    Nope, it isn't possible without a 3rd party tool. As far as I know no current version of Windows ships with a built in SFTP client, though I'm happy to be corrected if anyone knows better.

    I use WinSCP for this sort of thing. It's free and fairly easy to script.

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

  • February 2, 2012 at 2:15 am

    #1441607

    Thanks's for your reply..

    I have implemented the SFTP using WinSCP. but, this third party tool does not return any success or failure flag,

    How can I sure that file has been sftp successfully.

  • February 2, 2012 at 2:15 am

    #1441608

    Not easily. You're basically stuck either using a 3rd party tool (like WinSCP etc.) and calling it from the command line in an Execute Process Task, a 3rd party SSIS component (e.g. CozyRoc SFTP etc.) or a 3rd party .Net library (e.g. SharpSSH) and embedding that in your own component. Either way, you're using 3rd party code for the actual SFTP support.

  • February 2, 2012 at 2:22 am

    #1441612

    rakeshraj.sinha (2/2/2012)

    Thanks's for your reply..

    I have implemented the SFTP using WinSCP. but, this third party tool does not return any success or failure flag,

    How can I sure that file has been sftp successfully.

    If everything works fine WinSCP returns a status of 0, any error it returns status 1.

    To properly confirm that a file's uploaded you're going to need the recieving server to respond with something meaningful. Most of my SFTP/SCP transfers are going to Unix boxes so I use WinSCP's remote execution function to run a check script on the remote box to calculate checksums, which I then pull back and compare to those taken locally.

    blog | napalmgram@Twitter

    Training cats makes SQL Server look easy

  • February 2, 2012 at 2:26 am

    #1441618

    Thanks, will check and let you know..

  • February 2, 2012 at 3:00 am

    #1441637

    You have 4 options that I can see:

    -3rd party command line tool

    -3rd party dll and .net script task in SSIS

    -3rd party dll and .net CLR function

    -Build your own

    I'd err on the side of a 3rd party dll so you can configure your own success decision. I'd avoid using the dll from TSQL directly if you can help it, more pain than its worth.

    -edit-

    thought of option four

Viewing 9 posts - 1 through 8 (of 8 total)

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