Post reply

SQL Server 2012 SSIS – Sending files using FTP Task

  • February 23, 2012 at 12:08 am

    #256219

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

    Raunak J

  • February 23, 2012 at 1:49 am

    #1450688

    Can the task be configured to use SFTP?

  • February 23, 2012 at 2:00 am

    #1450693

    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

  • February 23, 2012 at 4:13 am

    #1450746

    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?

  • February 23, 2012 at 5:10 am

    #1450770

    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

  • February 23, 2012 at 5:17 am

    #1450774

    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

  • February 23, 2012 at 5:29 am

    #1450777

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

    Raunak J

  • February 23, 2012 at 5:32 am

    #1450778

    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

  • February 23, 2012 at 6:14 am

    #1450791

    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.

  • February 23, 2012 at 7:11 am

    #1450836

    Is this only available for SQL Server 2012?

  • February 23, 2012 at 7:40 am

    #1450863

    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/

  • February 23, 2012 at 7:50 am

    #1450875

    Thanks for the follow-up, guys.

  • February 23, 2012 at 7:50 am

    #1450876

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

  • February 23, 2012 at 8:03 am

    #1450881

    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.

  • February 23, 2012 at 8:59 am

    #1450928

    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 28 total)

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