When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for auditing purposes, or you include it directly in the output table, the odds are good that you’ll want to have that filename for use later in the process. You could do...
The post Extract the File Name in SSIS Data Flows using the FileNameColumnName Property appeared first on Tim Mitchell.
