I am trying to create an ssis package trying to pull the data from teh csv files into the oracle tables.
I am trying to get 6 files from the local C drive and it has files such as
what i need to do is i need to loop through the files and get teh file name into the variable each time we loop through the file and get the column name into one of the "TargetSource" field that I have in the table.
So each time I looop through the data from the csv file I need to get the filename into the column along with the data.
and then the second file .... had to do the same thing get teh file name along with other column values and so on...
Like wise for all teh 6 files.
So that when the data is loaded into the table I can check using the source which represents the filename.