Microsoft
70-448 · Question #111
You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task for Company.com. In order to change the package to write the whole rows that gets errors to a…
The correct answer is C. You should utilize a Flat File Destination component. E. You should increase an Error output to the Data Flow component. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task for Company.com. In order to change the package to write the whole rows that gets errors to a doc file. Which is the correct answer? (Select more than one)
Options
- AFor the doc file, you should utilize the SSRS log provider.
- BFor the SQL Provider, you should utilize the SSRS log provider.
- CYou should utilize a Flat File Destination component.
- DYou should utilize a text File Destination component.
- EYou should increase an Error output to the Data Flow component
How the community answered
(39 responses)- A8% (3)
- B3% (1)
- C77% (30)
- D13% (5)
Community Discussion
No community discussion yet for this question.