Connector/Net and SSIS

[Phillip Doughty]

Hi,

I am using sql server integration services and the Connector/NET to extract data from 2 mysql sources.

1. AWS Aurora (MySQL Version 8.0.36)
2. Magento Cloud (MariaDB)

What I am struggling with is they work with different Connector Versions. I need to run my connections with AWS Aurora with mysql-connector-net-8.0.32. Magento Cloud runs with mysql-connector-net-9.1.0

On my server, I cannot run both versions so I have to keep swapping versions or run on different servers.

Does anyone have any suggestions on how I could get them to coexist ?

Thanks