We have one source folder and three different file formats, all of .txt type. We might have a 2 of the same file format with different timestamps...
FILE1 - TIMESTAMP1.txtFILE2 - TIMESTAMP1.txtFILE3 - TIMESTAMP1.txtFILE1 - TIMESTAMP2.txt
Then we have 3 SSIS packages. SSIS1 would run against FILE1, SSIS2 against FILE2, etc.
How do I tell SSIS1 to only pick up and work with FILE1 files, SSIS2 to pick up FILE2 files, etc? Or, is this even possible?
In the master package use a foreach loop task to loop through the file.
Save the file Name to a variable FileName
In the loop put a dummy Script task and connect 3 Execute Package Task(one for each child Package)
In the precedence constraint set the expression to read the file name and decide something like:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?