I have a DTS package that imports the data from csv file into the table everyday. I Now the import filename is different (with datetimestamp) every day.
Two questions:
1. I am trying to use global variable to create a file name dynamically but somehow not able to use it into the import process.
2. I have added one extra column into the destination table, I want to have a import filename into it so that I can track which row is from which file.
How to do this?
Thank you