SSIS custom Connection Manager and SQL Server 2019: "Value does not fall within the expected range."

onic 1 Reputation point
2022-02-15T08:10:24.63+00:00

I'm trying to make a custom SSIS Connection Manager and make it works with my package.

First I've followed the official Microsoft documentation :

https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/connection-manager/creating-a-custom-connection-manager?view=sql-server-ver15#getting-started-with-a-custom-connection-manager
https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/connection-manager/coding-a-custom-connection-manager?view=sql-server-ver15
Then installed it with :

@SET GACUTIL="C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\gacutil.exe"  
  
Echo Copying files 2016  
@SET CONNECTIONSDIR130="C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections"  
copy "$(TargetDir)$(TargetFileName)" %CONNECTIONSDIR130%  
  
Echo Copying files 2017  
@SET CONNECTIONSDIR140="C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Connections"  
copy "$(TargetDir)$(TargetFileName)" %CONNECTIONSDIR140%  
  
Echo Copying files 2019  
@SET CONNECTIONSDIR="C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Connections"  
copy "$(TargetDir)$(TargetFileName)" %CONNECTIONSDIR%  
  
Echo Installing $(TargetFileName) in GAC  
%GACUTIL% -if "$(TargetDir)$(TargetFileName)"  

The custom connection manager is working fine if my SSIS package is configured with "TargetServerVersion":"SQL Server 2016" but when I set it to "SQL Server 2019" it doesn't work at all and throws this error :

Exception deserializing the package "Value does not fall within the expected range." (Microsoft.DataTransformationServices.VsIntegration)

174392-ssis-error.png

During my tests I use an empty package which only contains the connection.

Another finding if the custom connection manageris directly in the package (not in the project) the package runs but the connection is like ignored. If I put it in the project I have the error directly when executing the package.

Does anyone faced this error before ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.