无法使用SSIS包使用ADF-V2将数据从MySql同步到AzureSql [英] Not able to use SSIS package to Sync Data from MySql to AzureSql using ADF-V2

问题描述

因为我们可以在ADF-v2上运行SSIS包.

As we can run SSIS package on ADF-v2.

因此，我准备了一个SSIS包以在Mysql和Azure SQL之间同步记录 并低于报告中的错误

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

我尝试使用ODBC和ADO.Net连接，但是尝试从SSIS目录执行时得到相同的结果.

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

当我尝试从SSDT执行程序包时，我能够同步记录

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

问题:除了Azure云连接器，我们不能在ADF-v2中使用SSIS吗?

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

还请建议我是否缺少任何步骤.

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

用于实现相同功能的参考链接 Link1 和 Link2

Reference links used to implement same Link1 and Link2

推荐答案

您可能需要通过仍在Private Preview中的自定义安装界面在Azure-SSIS IR上安装MySQL ADO.NET/ODBC驱动程序.请填写我们的在线调查以加入: https://www.surveybuilder.com/s/Dg6Bq?source_type = email .

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.

这篇关于无法使用SSIS包使用ADF-V2将数据从MySql同步到AzureSql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！