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.)
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