Post reply

SSIS Synchronize Remote FTP Directory

  • September 11, 2008 at 4:50 pm

    #197746

    Comments posted to this topic are about the item SSIS Synchronize Remote FTP Directory

    Tommy

    Follow @sqlscribe

  • November 11, 2008 at 10:06 am

    #897045

    Tommy

    Thank you for this example code. It saved my life as I wasted a lot of time trying to use the FTP task which will not accept a password variable as one of its expressions.

    I adapted your code so that I could loop through a list of FTP sites (held in a table), connect to them and download any files on them (not a lot to ask you would think). I am getting more disillusioned with SSIS the more I work with it.

    If articles like yours weren't published the SSIS community would be stuffed.

    Thanks again

    Peter Doyle

  • November 11, 2008 at 2:19 pm

    #897165

    Peter Doyle (11/11/2008)

    Tommy

    Thank you for this example code. It saved my life as I wasted a lot of time trying to use the FTP task which will not accept a password variable as one of its expressions.

    I adapted your code so that I could loop through a list of FTP sites (held in a table), connect to them and download any files on them (not a lot to ask you would think). I am getting more disillusioned with SSIS the more I work with it.

    If articles like yours weren't published the SSIS community would be stuffed.

    Thanks again

    Peter Doyle

    Thank you Peter, I'm glad to hear it helped you out 🙂

    Tommy

    Follow @sqlscribe

  • June 2, 2009 at 2:52 am

    #1003232

    Thanks Tommy..

    This helped me alot and simplified my life. It integrated quite well with my existing package and I think this script is a keeper (at least for me)..

  • November 4, 2014 at 12:48 pm

    #1756604

    Thank you guys! Really helped a lot!

  • December 9, 2014 at 12:33 pm

    #1763630

    Does this script works if a new version of the same file copied to ftp site? File name stays the same only date modified updated? Please let me know

  • May 2, 2016 at 1:15 pm

    #1876025

    Thanks for the script.

  • June 11, 2019 at 2:56 pm

    #3652354

    Thnk

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

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