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:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx



Leave a Reply 2

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


Henry Figgins

Henry Figgins

This can’t be complete. After you’re foreaching through all the files in the directory, you still have to take the data out of the file and feed it into the table with a flat file connection and a data insert task:
You need to load data from all copied files to a destination table in SQL Server.

Where’s that part of the answer?

Tanzila

Tanzila

I will go with the given answer