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屋！