SSIS for each loop

Last Post 30 Jan 2009 06:50 AM by jase74. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
jase74
New Member
New Member

--
30 Jan 2009 06:34 AM
Hi,

I need some help with a for each container...


I have a foreach loop that will loop through a collection and sets a
directory variable and a couple of variables to with connection
strings, within the foreach loop there is another for each loop that
will process each file within the directory, if there are no files in
the first loop the container will just complete successfully but not
move on to the next item in the original collection. It only moves on
when there is a file in the first loop.


Is there anyway to force it to move if there are no files to process?


I hope this makes sense.


Jason


jase74
New Member
New Member

--
30 Jan 2009 06:50 AM
I've found the issue, I had a script task that was setting a incorrect directory path.


Acceptable Use Policy
---