PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform?

You modify a SQL Server 2008 Integration Services (SSIS) package.
The package extracts data from a text file and loads this data to a SQL Server 2008 table as
shown in the following two exhibits.

You need to update the package to extract data from multiple text files of the same directory.
Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)

PrepAway - Latest Free Exam Questions & Answers

A.
Add a variable to the package.

B.
Add a variable to the data flow task.

C.
Add a Foreach Loop container to the package.

D.
Add a For Loop container to the package.

E.
Add an expression to the Flat File Source component.

F.
Add an expression to the Flat File connection manager.


Leave a Reply