You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation.
To permit the transformation to continue, the package must perform the following tasks:
1 Ascertain which rows are affected.
2 Insert the rows that fail into a table.
3 Continue with the process.
You need to change certain properties in the package to meet the requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
A.
Choose the Redirect Row option for the Error property on the key column.
B.
Choose the Ignore Failure option for the Error property on the key column.
C.
Choose the Fail Component option for the Error property on the key column.
D.
Add a DataReader source to use a new Data Flow destination when the Failure constraint is fired.
E.
Add a DataReader source to use a new Data Flow destination when the Completion constraint is fired.
F.
Edit the Error Output properties for each DataReader source and configure each data source for error handling.