February 10, 2009 at 3:20 pm
Like many others, i do have an issue with a file system task. I'm using SSIS 2k5 SP3.
I simply want to iterate through a set of files, dynamically.
To do that I've added a Foreach Loop Container with a File System Task inside it.
A variable has been declared to hand over the current file name read in the for each loop to the file system task.
The file system task has been configured with "IsSourcePathVariable" = true and "SourceVariable" with the variable declare earlier.
The message I get is : "Variable xyz is used as a source or destination and is empty."
Therefore to test that assertion, I've added a script task inside the foreach loop container which simply raise a msgbox telling me the variable value which of course is filled with the correct file name each time a loop is done!
I've read several post and I should have misinterpret them because it is so a simple task to do yet it does not work 🙁
What am I doing wrong?
Thks
February 10, 2009 at 8:14 pm
It appears that you've covered your bases... can you post a screenshot of your ForEach loop settings?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
February 11, 2009 at 6:39 am
Of course!
Here they are! I hope these will help you help me 🙂
Forgot to add: Expressions tabs are always empty therefore I did not include any screenshot of those
February 11, 2009 at 7:54 am
I did find why !!! ($%?%&$)
I don't recall anyone saying this on any post. (Or maybe I read them too fast :Whistling: )
On the file system task, the property "DelayValidation" should be set to "True" instead of the default value of "False". That alone solved my issue!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply