MySQL Connection Manager fails in project set with TargetServerVersion SQL 2019
Posted: Wed 27 May 2020 04:35
Hi,
I have installed the latest Devart connection manager for MySQL on a Windows Server 2016 and SQL 2019 Standard Edition. Using VisualStudio SSDT 15.9.23. I am getting below errors in SSDT when the project is configured as TargetServerVersion SQL 2019.
[SSIS.Pipeline] Error: The component metadata for "Devart MySql Source, clsid {7CDF593F-DE06-4ABD-B356-7976EF7AC8E0}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
[SSIS.Pipeline] Error: Cannot find the connection manager with ID "{0C741C0F-3F7D-4445-9701-AF271F8ADBB0}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "Devart MySql Source.Connections[Devart MySql]" in the connection manager collection of "Devart MySql Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
In above case, I created a clean project with TargetServerVersion SQL 2019, and added the connection to a package.
However if I create a project with TargetServerVersion SQL 2017 it works except when running as a SQL Server Job.
I can see that there is Devart.SSIS.MySql.150.dll in the Assemblies folder. Could it be that SSDT is selecting the wrong dll when in TargetServerVersion SQL 2019 or what I am missing?
Update:
I can see that the right .dll is used but it still doesn't work.
Devart.SSIS.MySql.MySqlSource, Devart.SSIS.MySql.150, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
I have installed the latest Devart connection manager for MySQL on a Windows Server 2016 and SQL 2019 Standard Edition. Using VisualStudio SSDT 15.9.23. I am getting below errors in SSDT when the project is configured as TargetServerVersion SQL 2019.
[SSIS.Pipeline] Error: The component metadata for "Devart MySql Source, clsid {7CDF593F-DE06-4ABD-B356-7976EF7AC8E0}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
[SSIS.Pipeline] Error: Cannot find the connection manager with ID "{0C741C0F-3F7D-4445-9701-AF271F8ADBB0}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "Devart MySql Source.Connections[Devart MySql]" in the connection manager collection of "Devart MySql Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
In above case, I created a clean project with TargetServerVersion SQL 2019, and added the connection to a package.
However if I create a project with TargetServerVersion SQL 2017 it works except when running as a SQL Server Job.
I can see that there is Devart.SSIS.MySql.150.dll in the Assemblies folder. Could it be that SSDT is selecting the wrong dll when in TargetServerVersion SQL 2019 or what I am missing?
Update:
I can see that the right .dll is used but it still doesn't work.
Devart.SSIS.MySql.MySqlSource, Devart.SSIS.MySql.150, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701