Upgrade mapping schema for custom components, SSIS 2005 to 2008

dougbert — Tue, 10 Jun 2008 14:02:40 GMT

This is the schema for the mapping file that must be provided by developers of custom components to their customers, to support the automated upgrade of packages that contain their custom objects from the 2005 package and component version to the 2008 version.

For more information, see the Books Online topic Upgrading Custom Objects for SQL Server 2008 Integration Services.

Enhanced Error Output

dougbert — Sat, 10 May 2008 16:32:50 GMT

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:

a script to create the SQL Server reference table for storing column information;
a console application in VB.NET that populates the reference table;
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:

In the script, enter your database name in the USE statement and change the table name if you prefer.
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.
In the package, fix the connection manager to connect to your test database and table.

Integration Services downloads

Upgrade mapping schema for custom components, SSIS 2005 to 2008

Enhanced Error Output