Not able to use SSIS package to Sync Data from MyS

问题:

As we can run SSIS package on ADF-v2.

So I've prepared an SSIS package to Sync records between Mysql and Azure SQL and getting below error in reports

I'm tried using ODBC and ADO.Net connection but getting same result when trying executing from SSIS catalog.

I'm able to sync records when i tried executing package from SSDT

Question : Can't we use SSIS in ADF-v2, other than Azure cloud connecters?

Also please suggest if there any steps i'm missing.

Reference links used to implement same Link1 and Link2

回答1:

You might need to install MySQL ADO.NET/ODBC driver on your Azure-SSIS IR via our custom setup interface that's still in Private Preview. Please fill out our online survey to join: https://www.surveybuilder.com/s/Dg6Bq?source_type=email.