Thursday, September 8, 2011

How to add SSIS Custom component to the SSIS Toolbox in Denali CTP3

Recently I try to convert the SQL 2008 SSIS packages to “Denali CTP3” version. Those packages are using the custom components. After recompiling the customer components to reference the SQL 11.0 objects, I need to add them into the SSIS Toolbox.

In BIDS 2008, I could open the Choose Toolbox Items option from the Tool menu to add those customer components.

image       image

 

In SQL Denali CTP3, the new SSIS Toolbox does not have a "Choose Toolbox Items" option. It will automatically detect new custom components, and add them to the SSIS toolbox.  If you cannot find them, you could do the following:

  • Make sure you add your task/component to the appropriate SSIS folder i.e. “C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\” or “C:\Program Files\Microsoft SQL Server\110\DTS\Tasks\”
  • Open the SSIS Toolbox by clicking the SSIS Toolbox button that is located on the top-right corner of the package design surface.

image

  • Right click on the Toolbox and select the Refresh Toolbox option.

image

Reference:

http://social.technet.microsoft.com/wiki/contents/articles/ssis-toolbox-in-sql-server-denali-ctp1.aspx

3 comments:

  1. In this tool box they have found several project to solve in a particular time.On the other hand they have to send this to their owner through a mail.






    Tablet PC

    ReplyDelete
  2. Recently I try to convert the SQL 2008 SSIS packages to “Denali CTP3” version. Those packages are using the custom components. After recompiling the customer components to reference the SQL 11.0 objects, I need to add them into the SSIS Toolbox.patent art

    ReplyDelete