We are trialling the use of dotConnect for MySQL prior to purchasing.
Everything works fine when running in Visual Studio but deploying the package to the SSIS catalog and running from there (on the same server as Visual Studio is working) results in the error:
The managed pipeline component "Devart.SSIS.MySql.MySqlDestination" could not be loaded. The exception was: Could not load type 'Devart.SSIS.MySql.MySqlDestination' from assembly 'Microsoft.SqlServer.PipelineHost, Version=13.0.0.0, Culture=neutral, PublicKey=..."
Can anyone advise what's wrong? As this works in Visual Studio directly, I'm presuming that the components are installed correctly.
Thanks.
Deployed package can't use dotConnect for MySQL objects
Re: Deployed package can't use dotConnect for MySQL objects
Devart.SSIS.MySql.110.dll is designed for SQL Server 2012.
Devart.SSIS.MySql.120.dll is designed for SQL Server 2014.
Devart.SSIS.MySql.130.dll is designed for SQL Server 2016.
Devart.SSIS.MySql.140.dll is designed for SQL Server 2017.
Devart.SSIS.MySql.150.dll is designed for SQL Server 2019.
Make sure that TargetServerVersion in the properties of your SSIS project and the version of SQL Server you deployed your package are the same.
So if you developed your package with TargetServerVersion=SQL Server 2016 in SSIS project settings, but then deployed it to SQL Server 2019, you should open the *.dtsx package with XML Editor and replace "Devart.SSIS.MySql.130" with "Devart.SSIS.MySql.150".
Devart.SSIS.MySql.120.dll is designed for SQL Server 2014.
Devart.SSIS.MySql.130.dll is designed for SQL Server 2016.
Devart.SSIS.MySql.140.dll is designed for SQL Server 2017.
Devart.SSIS.MySql.150.dll is designed for SQL Server 2019.
Make sure that TargetServerVersion in the properties of your SSIS project and the version of SQL Server you deployed your package are the same.
So if you developed your package with TargetServerVersion=SQL Server 2016 in SSIS project settings, but then deployed it to SQL Server 2019, you should open the *.dtsx package with XML Editor and replace "Devart.SSIS.MySql.130" with "Devart.SSIS.MySql.150".
Re: Deployed package can't use dotConnect for MySQL objects
I can confirm that the development target is 2016, as is the installation instance.
In addition, looking in the *.dtsx package files I don’t find the references mentioned. Instead, all I see are lines of the form:
In addition, looking in the *.dtsx package files I don’t find the references mentioned. Instead, all I see are lines of the form:
- name="UserComponentTypeName">Devart.SSIS.MySql.MySqlDestination</property>
- name="UserComponentTypeName">Devart.SSIS.MySql.MySqlSource</property>
Re: Deployed package can't use dotConnect for MySQL objects
Our product line includes two products with SSIS functionality for MySQL. The code generated by one product will not work with another product:
"SSIS Data Flow Components for MySQL"
"dotConnect for MySQL Professional"
1. Tell us the name of Devart product you are working with.
2. Did you generate the package with the same product?
"SSIS Data Flow Components for MySQL"
Code: Select all
name="UserComponentTypeName">Devart.SSIS.MySql.MySqlDestination</property>
name="UserComponentTypeName">Devart.SSIS.MySql.MySqlSource</property>
Code: Select all
name="UserComponentTypeName">Devart.SSIS.MySql.MySqlDestination, Devart.SSIS.MySql.130, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701</property>
name="UserComponentTypeName">Devart.SSIS.MySql.MySqlSource, Devart.SSIS.MySql.130, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701</property>
2. Did you generate the package with the same product?
Re: Deployed package can't use dotConnect for MySQL objects
3. Visual Studio (package works) and SQL Server 2016 (package fails) are on the same workstation, aren't they?
4. Specify the capacity (x64 or x86) of your SQL Server 2016.
5. Make sure that the following assemblies are available on your workstation:
* "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Devart.SSIS.MySql.130\" (folder)
* "C:\Program Files\Microsoft SQL Server\130\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"
4. Specify the capacity (x64 or x86) of your SQL Server 2016.
5. Make sure that the following assemblies are available on your workstation:
* "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Devart.SSIS.MySql.130\" (folder)
* "C:\Program Files\Microsoft SQL Server\130\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"