Deploying Custom SSIS Components

This post is really for me.  I have written 1 custom component for SSIS 2005 and wrote an article on it for SQLServerCentral that was recently re-published.  In the discussion someone asked for specific steps for installing and using it.  Well, since it has been about a year, I couldn’t remember all the specifics so I’m blogging the steps so I have place to go the next time I need it.  So on with the steps:

1. Register the component in the GAC (Global Assembly Cache).  There are 2 ways to this:
   • Drag and drop the component into C:\Windows\Assembly
   • Use the GAC utility that that is part of the Visual Studio SDK and the Windows SDK.  Here is the syntax:
     gacutil.exe  /if Path\AssemblyName
   • Depending on which one you installed it will be located in one (or both) of these locations if you used the default install:
     • C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin
     • C:\Program Files\Microsoft SDKs\Windows\v6.0\Bin
2. On your development machine put the component in one of the folders under C:\Program Files\Microsoft SQL Server\90\DTS (default install location):
   • \Connections
   • \ForEachEnumerators
   • \LogProviders
   • \PipelineComponents
   • \Tasks

The component I created is a Pipeline Component so it belongs in the PiplelineComponents folder.  Once you have put it here you can add it to your toolbox by right-clicking on the toolbox, selecting “Choose Items”, select the SSIS Data Flow Items tab (in this case), and select the Error Details component.

This is really a summarization of this blog post by Matthew Roche that you can read for more details.