SQL Server 2012 SSIS – Sending files using FTP Task

  • Raunak Jhawar

    SSCoach

    Points: 15701

    Comments posted to this topic are about the item SQL Server 2012 SSIS – Sending files using FTP Task

    Raunak J

  • peter.row

    SSCarpal Tunnel

    Points: 4306

    Can the task be configured to use SFTP?

  • Raunak Jhawar

    SSCoach

    Points: 15701

    No, the FTP task cannot be used to establish a secure FTP connection.

    Nevertheless, you can follow my blog on SFTP using SSIS here

    Raunak J

  • DbRob

    SSC Veteran

    Points: 286

    Raunak Jhawar (2/23/2012)


    No, the FTP task cannot be used to establish a secure FTP connection.

    I can't believe they didn't provide native support for this- does anyone at Microsoft actually have any real world experience that they are drawing from?

  • George H.

    Default port

    Points: 1462

    No native SFTP support is really disappointing. We have been using the execute process task to run a vb.net program to perform the SFTP functionality, but it would have been nice for MS to include SFTP in the FTP task.

    Nice, concise article though!

    Thanks, George

  • CGSJohnson

    SSCertifiable

    Points: 7047

    Nice article...thanks!

    What's the implication of opening the connection each time in the FEL? Or is SSIS smart enough to keep the single connection open for the duration of the FEL? Is there a send multiples option?

    Thanks...Chris

  • Raunak Jhawar

    SSCoach

    Points: 15701

    The IS Engine would open connection fetch/send all data and close connection.

    Raunak J

  • Raunak Jhawar

    SSCoach

    Points: 15701

    The looping construct will take care of the "Send Multiple" File, as it loops over the source folder structure to get file(s).

    Raunak J

  • Dan Graveen

    Mr or Mrs. 500

    Points: 525

    Nice post, though I didn't want to loop to send multiple files. Instead I added a script task to create an FtpClientConnection and passed a string array to the FtpClientConnection.SendFiles() method.

  • pmcdonald

    SSC Rookie

    Points: 33

    Is this only available for SQL Server 2012?

  • shannonjk

    SSCarpal Tunnel

    Points: 4286

    Thank you for posting this article as I am sure it is useful to many.

    I am confused however as I have been doing this since 2005 and it still looks the same. What is specific to 2012?

    Link to my blog http://notyelf.com/

  • CGSJohnson

    SSCertifiable

    Points: 7047

    Thanks for the follow-up, guys.

  • CGSJohnson

    SSCertifiable

    Points: 7047

    For each iteration of the FEL? Or does it open one connection? Thanks.

  • TampaMike

    Grasshopper

    Points: 20

    Seriously??? STILL no SFTP support? And what about the ability to read a remote directory to see if a file exists. I bet they didn't add that either. Microsoft, you suck at life.

  • Nadrek

    SSC-Insane

    Points: 20039

    Raunak Jhawar (2/23/2012)


    No, the FTP task cannot be used to establish a secure FTP connection.

    Nevertheless, you can follow my blog on SFTP using SSIS here

    For anyone wondering "What's wrong with FTP", the basic answer is: It sends both the username and the password (and the data) across the network/internet in clear text; anyone operating or with rights to any of the network between client and server and see not only the data you're sending that time, but they have the username and password you just used, and can use that at any time in the future they wish to.

Viewing 15 posts - 1 through 15 (of 29 total)

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