Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Synchronize Remote FTP Directory Expand / Collapse
Author
Message
Posted Thursday, September 11, 2008 4:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:38 AM
Points: 1,157, Visits: 3,270
Comments posted to this topic are about the item SSIS Synchronize Remote FTP Directory

Tommy

Post #568190
Posted Tuesday, November 11, 2008 10:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 8, 2014 2:57 AM
Points: 6, Visits: 240
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


Post #600788
Posted Tuesday, November 11, 2008 2:19 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:38 AM
Points: 1,157, Visits: 3,270
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

Post #600936
Posted Tuesday, June 2, 2009 2:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 3, 2010 4:04 AM
Points: 1, Visits: 36
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)..
Post #727224
Posted Tuesday, November 4, 2014 12:48 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 12:48 PM
Points: 564, Visits: 99
Thank you guys! Really helped a lot!
Post #1630877
Posted Tuesday, December 9, 2014 12:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 12:32 PM
Points: 4, Visits: 34
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
Post #1642753
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse