clucasi
SSCrazy
Points: 2113
More actions
June 18, 2014 at 9:27 am
#287666
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
:w00t:
PB_BI
SSCoach
Points: 17358
June 20, 2014 at 7:03 am
#1723570
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
🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply