问题描述
因为我们可以在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 SQLand 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.
Reference links used to implement sameLink1 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！