Upload flat files / add file name to table column

Question

I am trying to load a ton of flat files into a sql table and add a file name column to the table.

in the control flow I have 2 foreech loops that capture file names and pass them to two variables.

where I am having problems in my data stream, I first have a source file source pointing to a derived column then pointing to OLE DB Destination .. at the OLE DB destination it recognizes my file name, but when I run the package, it performs fine, it just creates a table, it does not insert flat file data or a file name from two variables

Answer 1

:

• .
• " " " " > "_" , .. _
• ok, , FileName , .

Answer 2

DataFlow Task. , Script Task Expression Task ForEach Loop container, DataFlow Task. , Delay Validation DataFlow Task True.