为什么我在SQL Server导入和导出向导中出现这些错误？ [英] Why do I get these errors in SQL Server Import and Export Wizard?

问题描述

我有FoxPro数据库，我需要转换为SQL数据库。我有SQL Server 2005，我正在将FoxPro DBC文件导入SQL Server Management Studio中的测试数据库。到目前为止连接正常，但我遇到了很多错误。当我必须选择要导入的数据库时，我会看到数据，并且只需更改一些数据类型，所有内容都可以正常显示。以下是预执行运行时出现的错误：

I have FoxPro Databases that I need to convert toSQL database. I have SQL Server 2005 and I am importing the FoxPro DBC file into a test database in SQL Server Management Studio. The connection are fine so far but I get a lot of errors. I see the data when I have to choose the databases to import and every thing looks ok with a few data type changes. Here is the errors I get when Pre-execute is running:

 Pre-execute (Error)
Messages
Warning 0x80202066: Data Flow Task: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.
 (SQL Server Import and Export Wizard)
 
Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E21  Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
 (SQL Server Import and Export Wizard)
 
Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
 (SQL Server Import and Export Wizard)
 
Error 0xc004701a: Data Flow Task: component "Destination - aa" (265) failed the pre-execute phase and returned error code 0xC0202025.
 (SQL Server Import and Export Wizard)

有没有办法解决这个问题？

Is there any way for this to be fixed?

推荐答案

您可能想尝试使用ODBC而不是OLE。看看这篇文章：

http://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database [ ^ ]

You may want to try using ODBC instead of OLE. Check out this article:
http://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database[^]

这篇关于为什么我在SQL Server导入和导出向导中出现这些错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！