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.
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.
- Right click on the Toolbox and select the Refresh Toolbox option.
Reference:
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.
ReplyDeleteTablet PC
thanks for the post
ReplyDeleteRecently 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