May
18
2010

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:

  1. Close BIDS or Visual Studio.
  2. Uninstall the old version of the component.
  3. Install the new version of the component, including the following steps:
    1. Copy the main assembly to the appropriate component folder under the 32-bit Program Files folder.
    2. Copy the main assembly to the appropriate component folder under the 64-bit Program Files folder.
    3. Install the appropriate assemblies in the global assembly cache (GAC).
  4. Stop and restart the SSIS service (because it caches the list of installed components).
  5. Restart BIDS or Visual Studio.
  6. If necessary, make manual adjustments to the list of custom components in the Toolbox.

Please email me at dougbert@dougbert.com with comments, clarifications, corrections, or curses. I have disabled comments on my blog due to the volume of spam, but I still like to hear from you!

-Doug