Source is a flat file. I want to load the data of the flat file into the target along with the file name. For example, the source is products data which is shown below:
source data:
columname:cat products.dat
Chocolate
Biscuit
The target should contain the below data:
Code:
product, filename
------------------------
Chocolate, products.dat
Biscuit, products.dat
how we achie this issuse in ssis plz tell me