SSIS 2005 Foreach loop
-
Hi,
Does anyone know why the foreach loop in ssis 2005 does not error out if the directory path specfied is invalid?
Is there any way I can do this? If the directory path is invalid it just gives me a warning message saying there are no files to loop through or the directory is empty.
I know I can probably write a script task before the foreach loop to achieve this but I just want to know if the foreach loop has a property that I can set to achieve this.
The magic and wonders of SSIS do not let me believe that there is no such property or a simple way of doing this
Thanks...
-
The reason there's no error is probably because the For Each Loop thinks it has no access rights, so there are no files to loop over.
So I would check it in a script task
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (3/30/2012)
The reason there's no error is probably because the For Each Loop thinks it has no access rights, so there are no files to loop over.So I would check it in a script task
My thoughts about this are that the FOREACH task has been deliberately engineered to be forgiving - it never generates errors if it does not find what it is looking for - which I think is what most people want.
-
Thank you both for your answers, I would understand if it doesnot error out when it does not find anything under the specified directory. But I find it a bit strange that id does not complain even when the directory path is completely invalid! Anyways, I'll go back to using my script task then ....
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply