• 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