DRAG DROP
You are building a SQL Server Integration Services (SSIS) package to load data from all files that are
automatically copied to a directory each night through an external FTP process.
You need to load data from all copied files to a destination table in SQL Server.Which three steps should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx
1. Open Control Flow page ( you cannot add ForEach or For loop to Data Flow).
2. Create ForEach Loop Container (we need to process all files, but we are not know about their quantity)
3. On the Collection page, select the Foreach File … ( because “load data from all files that are
automatically copied to a directory each night through an external FTP process”)