Multiple choice technology architecture

You are designing a 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?

  1. Use the SSIS log provider for the SQL Profiler

  2. Use the SSIS log provider for the text file

  3. Use a flat file destination component

  4. Use a Raw file Destination component

  5. Add an error output to the Data Flow component
Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

To write error rows to a text file, use the SSIS log provider for text files (B) to configure logging, and add an error output to the Data Flow component (E) so error rows are redirected instead of failing the package. Options A (SQL Profiler) is unrelated. Options C and D (destinations) are not logging mechanisms.

Keep practicing — related questions