SQL Server Blogs

This custom component is used to to add the column name an error occurred in to the data flow in Intergration Services.

This is not compatible with some older versions of the SQL 2005 version. If you have a component that takes 2 inputs then to use this new component you will need to delete the old one and drag the new one from the toolbox.

Installing the component,

1. Un Install any previous versions
2. Run the setup
3. Open VS and load or create a SSIS package
4. Open the toolbox, right click and select "Choose items..."
5. Select the SSIS Data Flow components tab
6. Check the check box next to the enhanced error component

This should now result in the Enhanced Error Component appearing in the toolbox.

To use the component it is simple,

1. Open your SSIS package
2. Drag the Enhanced error component onto the data flow.
3. Attach an error output to it
4. Double click on the component
5. Select whether you want to have the error column and/or the error description added to the flow.
6. Connect the output of the component to a destination or another component
7. Run your package.
8. If you add or change any columns you have to double click on the component again. This lets the component read the meta data of the package.

This has not had extensive testing with destination components. It is best for use when errors are raised against a single column.