Multiflatfile connection - Capture file name

[Sweenster]

Hi,

I importing multiple txt files in SSIS using a Multiflatfile connection with wildcard. Everything works fine as the number of files could vary at run time as files are each from a different source systems.

Now what i need to do is each time a file is processed, read the filename so I can populate a source column for splitting back out those rows at a later date

Is is possible to grab the file name somehow when using a wild card?

 

[Sweenster]

Don't worry I have found the answer..I was able to just use a custom property of the actual flat file source in the data flow!

CustomProperties:
FileNameColumnName

This captures the full path and name of the file being processed so did just the job!

Mark