Microsoft
70-448 · Question #327
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task. You need to modify the package to write all rows that generate errors to a text file…
The correct answer is C. Use a Flat File Destination component. E. Add an Error output to the Data Flow component. See the full explanation below for the reasoning.
Question
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task. You need to modify the package to write all rows that generate errors to a text file. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Options
- AUse the SSIS log provider for the SQL Profiler.
- BUse the SSIS log provider for the text file.
- CUse a Flat File Destination component.
- DUse a Raw File Destination component.
- EAdd an Error output to the Data Flow component
How the community answered
(64 responses)- A14% (9)
- B6% (4)
- C77% (49)
- D3% (2)
Community Discussion
No community discussion yet for this question.