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.)
Answer:
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx
Open Control Flow
Create Foreach Loop Container
On Collection Page, select Foreach File Enumerator
0
0
Correct
0
0