You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional
Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
* Ensure that the process supports the creation of an exception report that details
possible duplicate key values, null ratios within columns, and column-length distributions
of values.
* Ensure that users can generate the exception report in an XML format.
* Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice
may achieve the goal. Select the BEST answer.)