I have a got a list of files in a folder text file with names like this:
Keep in mind>> there is no date column within each the text file.
I want to a do a SSIS (SQL Server Integration Services) loop where I loop through each file and insert it into a stage table which has an extra empty “Reportdate” column at the very end.
The SSIS job then gets the date from the file name and inserts it into the very last “ReportDate” column in that stage table
How do I do that?