Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, August 18, 2016 5:39 AM
Points: 1,160, Visits: 3,359
Comments posted to this topic are about the item SSIS Synchronize Remote FTP Directory

Tommy

Follow @sqlscribe
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: Tuesday, February 2, 2016 10:54 AM
Points: 6, Visits: 273
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: Thursday, August 18, 2016 5:39 AM
Points: 1,160, Visits: 3,359
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
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: Wednesday, June 10, 2015 1:20 AM
Points: 1, Visits: 44
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: Wednesday, April 6, 2016 9:14 AM
Points: 567, Visits: 104
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
Posted Monday, May 2, 2016 1:15 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 8,328, Visits: 858
Thanks for the script.
Post #1782652
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse