Which three steps should you perform in sequence?

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.)

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.)

Answer:

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Zemog

Zemog

1 control flow
2 for each loop container
3 for each file enumerator