Enhanced Error Output

This sample demonstrates one approach for adding both ErrorDescription and ErrorColumnName to an Integration Services Error Output. The zip file contains a Visual Studio solution with 3 main items:

1. a script to create the SQL Server reference table for storing column information;
2. a console application in VB.NET that populates the reference table;
3. a package that demonstrates how to look up the column information and populate the 2 additional columns of error information

To run this sample on your computer, you have to make some minor edits to each item:

1. In the script, enter your database name in the USE statement and change the table name if you prefer.
2. In the console application, change the string constants at the top of the code for the database name, and the folder location of the packages that you want to use as a test.
3. In the package, fix the connection manager to connect to your test database and table.