SSIS Synchronize Remote FTP Directory

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

  • 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

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

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

  • Thank you guys! Really helped a lot!

  • 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

  • Thanks for the script.

  • Thnk

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

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