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.)
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Use the SSIS log provider for the SQL Profiler.
B.
Use the SSIS log provider for the text file.
C.
Use a Flat File Destination component.
D.
Use a Raw File Destination component.
E.
Add an Error output to the Data Flow component