Microsoft Exam Questions

Which is the correct answer to change the package to write the whole rows that gets errors to a doc

You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task for Company.com.

In order to change the package to write the whole rows that gets errors to a doc file.

Which is the correct answer? (Select more than one)

A.
For the doc file, you should utilize the SSRS log provider.

B.
For the SQL Provider, you should utilize the SSRS log provider.

C.
You should utilize a Flat File Destination component.

D.
You should utilize a text File Destination component.

E.
You should increase an Error output to the Data Flow component