{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 干净又极端 的问题《Not able to use SSIS package to Sync Data from MyS》','https://www.manongdao.com/q-1023007.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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
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.