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) I launch the Import and Export Data Wizard (32 bit).

  • SSRS Row Values To Column
  • SQL Query continues running for a very long time if search term not found
  • Stored procedure to insert values into dynamic table
  • datetime issue with 01/01/1900
  • Why is doing a top(1) on an indexed column in SQL Server slow?
  • xml serialization and for xml sql server
  • 2) Data source: .Net Framework Data Provider for Odbc.

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

    4) I set up a flat file destination.

    5) When I click “Next” I get the following error:

    TITLE: SQL Server Import and Export Wizard

    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.

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

       - Index was outside the bounds of the array.
    

    ADDITIONAL INFORMATION:

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

  • How can I run sql server stored procedures in parallel?
  • Unit Testing for VBScript, ASP Code and SQL Server 2000
  • SQL Server: importing from Excel, only want the new entries
  • SSIS XMLSource only seeing null values in XML variable
  • MySQL to SQL Server transferring data
  • Upgrading DTS packages to SSIS Packages
  • 2 Solutions collect form web for “SQL Server Import and Export Wizard Error: “Index was outside the bounds of the array” via 32bit ODBC data source?”

    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.

    I received the same error when tried to import from Sybase. It works when change to use the query instead to copy table.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.