Adding Custom Components to SSIS

Below are the basic steps for adding custom components to SSIS; however, for more in-depth information I highly recommend reading Matthew Roche’s post about deploying and testing custom SSIS components

1. Register the custom assembly in the Global Assembly Cache (GAC)

Copy the DLL to the c:\windows\assembly\ directory.  The easiest way is to drag and drop the DLL using Windows Explorer (right clicking on the DLL and doing a copy/paste will not work).  Alternatively you can use the command line utility called GACUTIL.EXE (for more info about GACUTIL see the link above to Matthew’s Roche’s post).  Either way you will need Admin rights. 

2. Copy the custom assembly to Visual Studio’s “special folder” 

Copy the DLL to the appropriate subfolder in the C:\Program Files\Microsoft SQL Server\90\DTS\ directory.  For Control Flow Tasks put the custom assembly in the Tasks folder; for Data Flow Tasks use the PipelineComponents folder.  Remember that Visual Studio is a 32 bit application.  If you’re running on a 64 bit machine, make sure to use the Program Files (x86) path, otherwise you won’t see your component listed in the Choose Toolbox Items window of Step 3.

3. Add the component to the SSIS toolbox 

Open an Integration Services project in Visual Studio, right click anywhere in the Toolbox, and select Choose Items.  Go to the appropriate tab in the Choose Toolbox Items window and select the appropriate components.  

This entry was posted in SSIS and tagged , , , . Bookmark the permalink.

One Response to Adding Custom Components to SSIS

  1. jims236 says:

    Great post, thanks for this. It helps me alot reviewing my ssis configurations.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>