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

FTP Task Expand / Collapse
Author
Message
Posted Wednesday, June 18, 2014 9:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:24 AM
Points: 94, Visits: 439
Hi,

How can i down the last 5 days data from FTP site using FTP Task when files are sequential 1,2,3,4,etc

Post #1583060
Posted Friday, June 20, 2014 7:03 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 481, Visits: 926
Firstly
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx


Secondly,
I think that you can achieve this with a combination of a For Each Loop Container and a variable for your file names. Or a script task if you're feeling dot-netty.

Have a read of this forum post which covers most options: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/cedd8052-4775-4f85-bd21-c1d2e803e9d9/for-each-loop-container-to-loop-through-files-in-ftp-site






I'm on LinkedIn
Post #1584337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse