Hello - I want to use the SSIS Foreach File Enumerator in a package that
loads files into one table, but also in that table update the filename
column to the name of the file

Thanks

When you pick up the file from the filesystem using the ForEach
enumerator you will be assigning the name of the file to a variable.
That variable in the pipeline can be the source for a derived Column.
This can then be used to be inserted into the destination table.

--
Regards



Allan Mitchell


Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com





"WalterWalt" <,> wrote