导入导出向导错误 [英] Import Export wizard error
本文介绍了导入导出向导错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
从MySQL DB导入数据时,我遇到以下错误。仅供参考...我创建了一个使用MySQL ODBC 8.0 Unicode驱动程序连接MySQL的DSN。
SQL Server中的数据源:.Net Fw Data Provider for Odbc
数据目标:SQL Server本机客户端11.0
TITLE:SQL Server导入和导出向导
------------------------------
$
无法连接源组件。
错误0xc02020ff:源 - 节点[1]:源 - 节点无法检索SQL命令的列信息。
发生以下错误:ERROR [42000] [MySQL] [ODBC 8.0(w)驱动程序] [mysqld-5.7.18]您的SQL语法出错;检查与您的MySQL服务器版本相对应的手册,以便在第1行的""节点"附近使用正确的语法。$ $
$
------------------------------
附加信息:
管道组件已从方法调用返回HRESULT错误代码0xC02020FF。 (Microsoft.SqlServer.DTSPipelineWrap)
--------------------------- ---
按钮:
OK
------------ ------------------
问候,Nayan
解决方案
嗨Nayan,
感谢您的提问。
您是否按照本文设置了相关配置?
连接到MySQL数据源(SQL Server导入和导出向导)
最好的问候,
将
Hi,
I am facing the below error while importing data from MySQL DB. FYI... I have created a DSN for connecting MySQL using MySQL ODBC 8.0 Unicode Driver.
Data Source in SQL Server: .Net Fw Data Provider for Odbc
Data Destination: SQL Server native Client 11.0
TITLE: SQL Server Import and Export Wizard------------------------------
Could not connect source component.
Error 0xc02020ff: Source - node [1]: The Source - node was unable to retrieve column information for the SQL command.
The following error occurred: ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.18]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"node"' at line 1
------------------------------
ADDITIONAL INFORMATION:
Pipeline component has returned HRESULT error code 0xC02020FF from a method call. (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
Regards, Nayan
解决方案
Hi Nayan,
Thanks for your question.
Have you followed this article to set up related configuration?
Connect to a MySQL Data Source (SQL Server Import and Export Wizard)
Best Regards,
Will
这篇关于导入导出向导错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文