PrepAway - Latest Free Exam Questions & Answers

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

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)

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply