InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:30:01 GMT20http://www.sqlservercentral.com/Forums/Topic568190-882-1.aspxThanks 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)..Tue, 02 Jun 2009 02:52:34 GMTahmad.mahomedhttp://www.sqlservercentral.com/Forums/Topic568190-882-1.aspx[quote][b]Peter Doyle (11/11/2008)[/b][hr]TommyThank 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 againPeter Doyle[/quote]Thank you Peter, I'm glad to hear it helped you out :) Tue, 11 Nov 2008 14:19:06 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic568190-882-1.aspxTommyThank 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 againPeter DoyleTue, 11 Nov 2008 10:06:12 GMTPeter Doyle-393489http://www.sqlservercentral.com/Forums/Topic568190-882-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL+Server+2005/64322/">SSIS Synchronize Remote FTP Directory</A>[/B]Thu, 11 Sep 2008 16:50:24 GMTTommy Bollhofer