PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains a Data Flow task with a Fuzzy Grouping transformation that creates data. The output of the Fuzzy Grouping transformation is incorrect. You need to view the output data of the Fuzzy Grouping transformation to debug the package. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add a Data Viewer object to the Data Flow task for constraints on the Fuzzy Grouping transformation.

B.
Add a Failure constraint to the Control Flow task after the Data Flow task that contains the Fuzzy Grouping transformation.

C.
Add a Data Flow task to the Control Flow task preceding the Data Flow task that contains the Fuzzy Grouping transformation to show the input data.

D.
Add a Failure constraint from the Data Flow task that contains the Fuzzy Grouping transformation to a new Data Flow task that exports the results.


Leave a Reply