You need to monitor the data that passes through each path in the data flow by using the Business Intelligence Development Studio

You design a SQL Server 2008 Integration Services (SSIS) package that contains several
data flows.
You need to monitor the data that passes through each path in the data flow by using the
Business Intelligence Development Studio. You also need to ensure that data flow logic is
retained.
What should you do?

You design a SQL Server 2008 Integration Services (SSIS) package that contains several
data flows.
You need to monitor the data that passes through each path in the data flow by using the
Business Intelligence Development Studio. You also need to ensure that data flow logic is
retained.
What should you do?

A.
Use the Data Viewer tool.

B.
Use the Data Profiling task.

C.
Use the Audit transformation.

D.
Use breakpoints in the Script component.



Leave a Reply 0

Your email address will not be published. Required fields are marked *