70-448 · Question #170
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. A Flat File Destination component should be used D. An Error output should be added to the Data Flow component. 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. Now you get an order from your company CIO, you are asked to design a SQL Server 2008 Integration Services (SSIS) package. The package contains a Data Flow task. According to the requirement of the company CIO, the package has to be modified to write all rows by which errors are generated to a text file. So what should you do? (choose more than one)
Options
- AA Flat File Destination component should be used
- BA Raw File Destination component should be used
- CThe SSIS log provider for the SQL Profiler should be used
- DAn Error output should be added to the Data Flow component
- EThe SSIS log provider for the text file should be used
How the community answered
(24 responses)- A83% (20)
- B4% (1)
- C4% (1)
- E8% (2)
Community Discussion
No community discussion yet for this question.