This post explains the steps required to build and deploy custom SSIS components. For the purpose of illustration, the Custom SSIS Data Flow Component – Credit Card Number Validator (CCNV) is used.
Step 1 – Create Strong Name Key (SNK) for the Assembly
From Visual Studio, open the Class Library of your Custom SSIS Component. Navigate to Project→Properties from toolbar
Navigate to the Signing tab and Select the options as shown in Figure 2.
Enter a Strong Name Key (SNK) file as shown in Figure 3. Protect it with a password (optional).
Step 2 – Build the Assembly
Step 3 – Deploy the Assembly to BIDS SSIS Folder
The SSIS Designer in BIDS locates the custom components available for use in packages by enumerating the files found in a series of folders located under C:\Program Files\Microsoft SQL Server\100\DTS\ (for SQL Server 2008) or C:\Program Files\Microsoft SQL Server\90\DTS\ (for SQL Server 2005). If your default SQL Server Installation uses a different path, then use the registry key HKLM\SOFTWARE\Microsoft\MSDTS\Setup\DtsPath to locate this folder.
Copy the Assembly from \bin folder to the appropriate sub-folder. The assembly for Data Flow Components like Credit Card Number Validator (CCNV05) is copied to the sub-folder PipelineComponents. Overwrite the Assembly if it already exists.
❗IMPORTANT: On 64-bit OS use the 32-bit Program Files folder e.g. C:\Program Files(x86)\Microsoft SQL Server\100\DTS\, since the current version of BIDS is still a 32-bit application.
Step 4 – Install the Assembly to Global Assembly Cache (GAC)
Navigate to %system%\assembly folder . It’s usually C:\Windows\Assembly. Drag and Drop the Assembly from \bin folder to %system%\assembly folder. If the assembly already exists, right-click and uninstall existing assembly and then install the new version.
IMPORTANT: You must close and reopen BIDS SSIS Designer after you install a new version of your custom object.
Step 5 – Adding the Custom Component to the Toolbox
Now comes the best part where you can see your custom component in action. From BIDS, open any SSIS project.
Right-click the toolbox and then click Choose Items (Figure 4).
In the Choose Toolbox Items dialog box, click the Data Flow Items and Select your custom component (Figure 5), in this case Credit Card Number Validator
Now your toolbar displays your Custom SSIS Data Flow Component (Figure 6).
Your Custom SSIS Component is now ready for Action.