I have a very simple data load process that I am running. I loop through text files in a folder on a file share and load the data into a database table. For this example let's say the file contains 3 columns: NAME | PHONE | AMOUNT. I would like to add a column to my DB table named FILE_INSERTED and have that populated with the name of the file.
Example: a file named MY_FILE_20171101.txt has 50 rows of data. I would like the column FILE_INSERTED for all 50 of those rows populated with MY_FILE_20171101.txt.
Currently the database table looks like this:
NAME | PHONE | AMOUNT
I want it to look like this
NAME | PHONE | AMOUNT|FILE_INSERTED
How do I add this to my DATA FLOW TASK as a column to be inserted into the DB table?