I have 150 data delimited text files that need to be imported to a text file. Each of them is named for the table for which they contain data e.g. address.txt contains data that needs to imported to the address table. So what I have done is create a
SSIS package that contains a ForEach loop that iterates through the the files, and has a Load Data field object. What I haven't been able to figure out is what logic needs to be added for the Data Flow. I know I will need a Flat File Source with a connection
source that is tied to file it is processing.
However, after all of that I am not sure what do because each text file contains a different table with different columns. Can someone explain to me how to handle this?
View Complete Post