SQL Server导入和导出向导错误:“索引超出数组的范围"通过32位ODBC数据源? [英] SQL Server Import and Export Wizard Error: "Index was outside the bounds of the array" via 32bit ODBC data source?

问题描述

我得到一个索引超出数组范围".执行以下操作时出错.

I get an "Index was outside the bounds of the array." error when I do the following.

1)我启动导入和导出数据向导(32位).

1) I launch the Import and Export Data Wizard (32 bit).

2)数据源:Odbc的.Net Framework数据提供程序.

2) Data source: .Net Framework Data Provider for Odbc.

3)我为已设置的32位Progress OpenEdge 10.2A ODBC驱动程序提供了连接字符串和DSN.

3) I provide a connection string and DSN for a 32 bit Progress OpenEdge 10.2A ODBC driver that I've set up.

4)我设置了一个平面文件目标.

4) I set up a flat file destination.

5)当我单击下一步"时，出现以下错误:

5) When I click "Next" I get the following error:

无法检索源和目标数据的列信息，或者源列的数据类型未正确映射到目标提供者上可用的数据类型.

Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider.

视觉"."PUB"."tlrtran"-> C:\ Documents and Settings \ user \ Desktop \ flat-file.txt:

"VISION"."PUB"."tlrtran" -> C:\Documents and Settings\user\Desktop\flat-file.txt:

   - Index was outside the bounds of the array.

---

其他信息:

---

ADDITIONAL INFORMATION:

索引超出了数组的范围. (Microsoft.DataTransformationServices.Controls)

Index was outside the bounds of the array. (Microsoft.DataTransformationServices.Controls)

推荐答案

当尝试从用于Sage MAS90软件的32位ProvideX ODBC驱动程序从DNS导入数据到SQL时，我收到了同样的错误.通过首先创建目标表，然后使用该选项编写查询而不是从一个或多个表或视图复制数据来解决此问题.

I received this same error when trying to import data into SQL from a DNS for 32 bit ProvideX ODBC driver for Sage MAS90 software. I got around it by creating the destination table first and then using the option to write a query instead of copy data from one or more tables or view.

这篇关于SQL Server导入和导出向导错误:“索引超出数组的范围"通过32位ODBC数据源?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！