Microsoft
70-448 · Question #282
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…
The correct answer is A. Add a variable to the package. C. Add a Foreach Loop container to the package. F. Add an expression to the Flat File connection manager. See the full explanation below for the reasoning.
Question
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.)
Exhibits
Options
- AAdd a variable to the package.
- BAdd a variable to the data flow task.
- CAdd a Foreach Loop container to the package.
- DAdd a For Loop container to the package.
- EAdd an expression to the Flat File Source component.
- FAdd an expression to the Flat File connection manager.
How the community answered
(46 responses)- A83% (38)
- B7% (3)
- D2% (1)
- E9% (4)
Community Discussion
No community discussion yet for this question.