How to keep a track of file that populated destination in SSIS ForEach File enumerator?

Question

I have a source folder from where I have to extract only text files and load into a Database. I could do that using Foreach file enumerator. I also want to maintain a column at Destination(OLEDB) which would keep a track of the file that populated the corresponding record.This is precisely what I want at my destination

Answer 1

In your foreach numerator you could assign the filenames to a variable. Add that to a derived column, and populate in your destination. Here is an example how you could do it:

Add your variable to derived column