File Metadata and Foreach Loop Container

  • 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

  • This was removed by the editor as SPAM

  • 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