Custom DataFlow Transformation not showing up in toolbox
I've created a custom data flow tranformation and it isn't showing up in the Tool Box Items to be added under the Data Flow Items tab (right click on tool box, 'Choose Items...', then clicked Data Flow Items).
I have done the following:
- signed the assembly,
- added to GAC,
- copied the dll to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents.
It worked previously when I was just starting out, however now I cannot see it. What would cause it to not show up? Everything compiles fine. How would I determine how to fix it so that it shows up?
[621 byte] By [
thames] at [2007-12-27]
Apart from the component being in the GAC, there are two key steps to be taken for a custom component to be recognized by the BI Studio:
placing the binary under the folder where SSIS design time checks to enumerate pipeline components, which is at <SQL Installation Folder>\90\DTS\Pipeline Components (I'd double check this on the target machine via the reg key at the very bottom, cause it could be different on a 64bit or in a production server)
annotating the component class so that SSIS layout system can reflect on the component and recognize it as a custom component : ComponentType has to be Source/Transformation(see below)
i.e.
[ DtsPipelineComponent(
ComponentType = ComponentType.SourceAdapter,
IconResource = "SSIS2K5.Samples.Transforms.ImageFileSrc.component.ico",
DisplayName="ImageFile Source",
Description="Retrieves EXIF information from JPG files",
CurrentVersion = 1)
Also make sure the installation path on the deployment box is the right one by looking up :HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\Setup\DtsPath
