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:
Reference:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx
1 control flow
2 for each loop container
3 for each file enumerator