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: 2 days ago @ 7:54 AM
Points: 95, Visits: 453
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 635, Visits: 1,213
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