Problem
TARGIT Custom SSIS tasks not available in SSIS Toolbox
Solutions
Data Tools - "TargetServerVersion" property
The latest version(s) of Data Tools are no longer specific to the SQL Server version. Instead, there is a target server version property on the SSIS project which needs to be set correctly. Check the link in the External links section of this page for futher information on the TargetServerVersion property.
Known issues
If the correct project (SQL Server) version is not selected, the SSIS tasks may not work correctly in Data Tools.
- Make sure to run BIDS / Data Tools as Administrator
- Make sure to use the version of BIDS / Data Tools that matches the Integration Services version. The version can be checked in Help->About. The versions of the products “SQL Server Analysis Services” and “SQL Server Integration Services” must be:
- 9.x for SQL Server 2005
- 10.x for SQL Server 2008/2008R2
- 11.x for SQL Server 2012
- 12.x for SQL Server 2014
- 13.x for SQL Server 2016
- 14.x for SQL Server 2017
- Check that the TARGIT.* dlls are in the correct folders by checking the folders of other, correctly working components (see screenshot 1)
- Data Readers should be in subfolder PipelineComponents
- Processing tasks should be in subfolder Tasks
- Connection managers should be in subfolder Connections
- Check that the TARGIT.* dlls are in the Global Assembly Cache. For most OS versions, this can be checked in C:\Windows\assembly\GAC_MSIL or, on later systems, C:\Windows\Microsoft.NET\assembly\GAC_MSIL.
- There are examples - though very few - where the components do not work unless the dlls are copied manually to an extra file system location. If none of the above solves the problem, try copying the TARGIT*.dll files from ..\Program Files (x86)\Microsoft SQL Server\<SQL Server version>\DTS\Tasks\* to ..\Program Files\Microsoft SQL Server\<SQL Server version>\DTS\Tasks\*
External links
Related articles