What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 20 Data Flow tasks. After executing the package, you notice an unexpected distribution of values in a table. You need to generate a histogram and view the histogram after each transformation. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 20 Data Flow tasks. After executing the package, you notice an unexpected distribution of values in a table. You need to generate a histogram and view the histogram after each transformation. What should you do?

A.
Use Microsoft Business Intelligence Development Studio (BIDS) to open the package. Use the Data Flow tab to add a data viewer to each Data Flow path.

B.
Use Microsoft Business Intelligence Development Studio (BIDS) to open the package. Use the Package Configurations Organizer to add the data viewer to a configuration file for each Data Flow task.

C.
Use the Package Migration Wizard to open the package. Create a configuration file that contains elements for each data viewer configuration. Edit the properties of the package to use the configuration file for each Data Flow task.

D.
Use the Execute Package Utility to run the package. Create a configuration file that contains elements for each data viewer configuration. Add the /ConfigFile parameter, followed by the name of the configuration file, to the Command Line property of the package.



Leave a Reply 0

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