January 4, 2007 at 10:21 am
Hello,
I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns.
I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through?
Thank you for your help!
CSDunn
January 8, 2007 at 8:00 am
This was removed by the editor as SPAM
January 9, 2007 at 8:25 am
Hi,
The foreach loop doesn't need to know the meta data for each file. The meta data you are describing is defined within the data source connection. You need to use the variable configured within the loop contained via an expression on the data source to updated the file location on each iteration of the foreach loop.
Regards
Daniel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply