Hi,
I usually update 'FileNameColumnName' property of the flatfile source in the dataflow task when I want to get the sourcefile name in my destination table. It works fine.
However, the same does not seem to happen when I am using ForEach Loop container. Though I have updated 'FileNameColumnName' property as 'SourceFile' and mapped to a column in destination column, all it gets is '/'. Is there anything different I need to do to get the source file name in my destination table when using FEL.
Any help is very much appreciated.
Thank you
Renuka
[font="Verdana"]Renuka__[/font]