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"
Mysql Connection Manager missing in SSIS package after deployement
Re: Mysql Connection Manager missing in SSIS package after deployement
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: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.
2. The correct paths for SQL Server 2016 are: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"
* "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.
Re: Mysql Connection Manager missing in SSIS package after deployement
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
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
Re: Mysql Connection Manager missing in SSIS package after deployement
All previous versions should be available in your Devart Account. If not, submit your request via our contact form.