70-448 · Question #316
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is A. An expression should be added to the Flat File connection manager B. A variable should be added to the package E. Ad Foreach Loop container should be added to the package. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. You make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at the following SQL Server 2008 table. The package loads the data extracted from a text file to this table. Now you receive an order from your company CIO, the package has to be updated to extract data from multiple text files of the same directory. In order to achieve this goal, what should you do? (Choose more than one)
Exhibit
Options
- AAn expression should be added to the Flat File connection manager
- BA variable should be added to the package
- CA For Loop container should be added to the package
- DA variable should be added to the data flow task
- EAd Foreach Loop container should be added to the package
- FAn expression should be added to the Flat File Source component
How the community answered
(30 responses)- A77% (23)
- C13% (4)
- D7% (2)
- F3% (1)
Community Discussion
No community discussion yet for this question.