What task or combo of tasks can I use in ssis 2015 to load different file names into different tables into sql server?
I have a for each look container using folder and filename variables. The initial dataflow task in the for each loop container does a conditional split on the file name (2 different file names) and inserts into a seperate initial staging table for each file. The inital data flow has 2 precedence constraints with expression and constraint for the filename and then processes to seperate subsequent dataflows for each file. Dataflow for file1 is reprocessing 1 extra file. screenprint attached. packageflow.docx