PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

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

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


Leave a Reply