SSIS-MySQL源:无法创建托管连接管理器 [英] SSIS - MySQL source: Could not create a managed connection manager
问题描述
我正在使用装有SQL Server数据工具的VS 2012.我有一个ADO NET Source,它使用.Net Providers \ MySQL数据提供程序,并试图将某些数据推送到OLE DB目标,该目标使用普通的SQL Server Native Client 11.0提供程序.一切似乎正常,我可以预览源中的数据,并且列映射良好-但是当我运行项目时,出现以下错误:
I'm using VS 2012 with SQL Server Data Tools installed. I have an ADO NET Source, which uses the .Net Providers\MySQL Data Provider and am trying to push some data to an OLE DB Destination, which uses a normal SQL Server Native Client 11.0 provider. Everything seems ok, I can preview data from the source and columns are mapped well - but when I run the project I get the following error:
[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {47479EC0-98BC-4664-A8F9-0FF0278969FD} with the following error message: "Could not create a managed connection manager.".
[SSIS.Pipeline] Error: ADO NET Source failed validation and returned error code 0xC0208449.
大多数Google热门歌曲都谈论将Run64BitRuntime设置为false.我的是灰色的,默认情况下是false.还有其他建议吗?
Most Google hits talk about setting the Run64BitRuntime to false. Mine is greyed out and defaulted to false already. Any other suggestions?
推荐答案
我最终使用了ODBC连接,并能够按照此步骤逐步进行操作,以使备用路由起作用: 将SSIS MySQL复制表复制到SQL Server
I ended up using an ODBC connection and was able to follow this post step by step to get an alternative route working: SSIS MySQL Copying Table to SQL Server
这篇关于SSIS-MySQL源:无法创建托管连接管理器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!