Adding/Removing custom components to the toolbox in BIDS
Well i’m developing some custom components of SSIS and then using them in the BIDS (Bussines Inteligence Development Studio)
I have found some problems when trying to add the custom components that i developed to the toolbox.
In Building, Deploying and Debugging Custom Objects they enumerate the following steps to accomplish that:
To add a custom component to the Toolbox
1. Right-click the toolbox and then click Choose Items.
2. In the Choose Toolbox Items dialog box, click the SSIS Control Flow Items tab for a task, or the SSIS Data Flow Items tab for a data flow component.
3. Click the check box next to your component, and then click OK.
Tried to following the step 2, but i couldn’t find my component in that list.
So i browsed it and selected. Then i had the following error:
There are no components in <DLLPATH> that can be placed on the toolbox
I deleted the assembly reference from the GAC and the “%ProgramFiles%\Microsoft SQL Server\90\DTS\PipelineComponents\” folder. And then copied again the Dll to the “pipelinecomponents” folder and re register the dll using the Gacutil (“gacutil.exe /if my.dll”).
And tried again, but with the same results…
Well, while i was googling about how to add this to the toolbox and to the dataflow i found this:
http://www.ivolva.com/ssis_wizards.html
Two templates for creating Dataflow components and Custom tasks.
Very useful! I will keep updating this…
