Mysql Connection Manager missing in SSIS package after deployement

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
medsdev
Posts: 2
Joined: Mon 01 Jun 2020 17:04

Mysql Connection Manager missing in SSIS package after deployement

Post by medsdev » Mon 01 Jun 2020 17:35

Hi,
i have installed SSIS Data Flow Components and everything seems fine, I tested locally using visual studio and SQL Server 2017 works fine and I don't have any issue, but when I deploy my packages in the integration services catalog I couldn't find the connection managers related to devart MySQL, since its Devart.SSIS.MySql.130 I installed a SQL server 2016 developer edition instance but it not working either.
Can you please help on this issue, it's getting more and more critical.

I checked all these files and I found all of them locally :
* "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Devart.SSIS.MySql.130\" (folder)

* "C:\Program Files\Microsoft SQL Server\150\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files\Microsoft SQL Server\150\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"

* "C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\150\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Mysql Connection Manager missing in SSIS package after deployement

Post by Shalex » Thu 04 Jun 2020 20:18

medsdev wrote: Mon 01 Jun 2020 17:35i have installed SSIS Data Flow Components and everything seems fine, I tested locally using visual studio and SQL Server 2017 works fine and I don't have any issue, but when I deploy my packages in the integration services catalog I couldn't find the connection managers related to devart MySQL, since its Devart.SSIS.MySql.130 I installed a SQL server 2016 developer edition instance but it not working either.
1. Is your Integration Service Catalog (SQL Server 2016) installed on the same workstation where the package works successfully with Visual Studio and SQL Server 2017?
medsdev wrote: Mon 01 Jun 2020 17:35 * "C:\Program Files\Microsoft SQL Server\150\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files\Microsoft SQL Server\150\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"

* "C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Connections\Devart.SSIS.MySql.130.dll"
* "C:\Program Files (x86)\Microsoft SQL Server\150\DTS\PipelineComponents\Devart.SSIS.MySql.130.dll"
2. The correct paths for SQL Server 2016 are:
* "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"

3. Specify the capacity (x86 or x64) of your SQL Server 2016.

medsdev
Posts: 2
Joined: Mon 01 Jun 2020 17:04

Re: Mysql Connection Manager missing in SSIS package after deployement

Post by medsdev » Sun 07 Jun 2020 15:07

Hi shalex
thank you very much for you feedback,i tried the new SSIS Data FLow Components 1.12 and it worked for me but when i check in Visual studio there is a notification pop up that say download a version that is previous to 09/08/2019 which i think its related to the license we have so my plan is to download SSIS Data FLow Components 1.10 to make it work(the SSIS Data FLow Components i was using was 1.8.775)please if you can provide me a link where i can find all SSIS Data FLow Components downloads link , let me answer your questions:
1/ yes correct in the same workstation
2/My bad i didnt write the correct path i missed that (150 is for sql server 2019 sorry) i found them in the folder 130
3/ the capacity of my capacity SQL Server 2016 is x64

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Mysql Connection Manager missing in SSIS package after deployement

Post by Shalex » Mon 08 Jun 2020 10:44

medsdev wrote: Sun 07 Jun 2020 15:07please if you can provide me a link where i can find all SSIS Data FLow Components downloads link
All previous versions should be available in your Devart Account. If not, submit your request via our contact form.

Post Reply