Hi,

I have a simple package importing files from FTP and then importing the contents into tables in the DWH.

So far so good,but it would be great to import the name of the files as well into the same destination tables in an additional column :file_name. The import is simply done by a data flow task, within a flat file source and a OLE db source.

My question is:

is it possible by using flat file connection to add the file name to a table in DWH?It is the same table where the content of the flat file is imported.

thanks a lot

You can use the FileNameColumnName property.  You will need to use the Advanced Editor to do it.  http://sqlblog.com/blogs/jamie_thomson/archive/2010/03/31/filenamecolumnname-property-flat-file-source-adapter-ssis-nugget.aspx