Installing a new version of an SSIS custom component

Recently a friend asked for help with the, uh, challenges of cleanly installing a new version or build of a custom component for SQL Server Integration Services (SSIS). Here are the steps: Close BIDS or Visual Studio. Uninstall the old version of the component. Install the new version of the component, including the following steps: Copy the main assembly to the appropriate component folder under the 32-bit Program Files folder. Copy the main assembly to the appropriate component folder under the 6... [More]

Upgrading Custom Components for SQL Server 2008 Integration Services

The SQL Server 2008 Books Online page in which we describe the steps for upgrading and redistributing custom components is now live: Upgrading Custom Objects for SQL Server 2008 Integration Services This topic is for shops that wrote a custom component for SQL Server 2005 Integration Services, and who now want to provide a new version of the same component for SQL Server 2008 Integration Services. If you choose to create a new version of your component for 2008, then in addition to recompiling against th... [More]