Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

Invalid Descriptor Index

Symptoms

When making an import of data using the Microsoft BCP utility into a table in MSSQL Server database, you may receive an error:

 SQLState = S1002, NativeError = 0
 Error = [Microsoft][SQL Server Native Client 11.0] Invalid Descriptor Index

Cause

This error message may appear when information in generated bcp file doesn't match the number of columns in table where data should be loaded.

Solution

First of all, please, verify whether you have checked all the required columns for migration on the “Specify DDL and Data Options” page on “DDL” tab, please see the screenshot for your reference:

Please, note that if you are doing the data load into a table that already exists in the database, the list of checked columns should be the same as the list of columns in the existed table.

If you have any other questions regarding the usage of our tool, please contact our support team: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/troubleshooting-guide/sql-server/import/invalid-descriptor-index.txt · Last modified: May 21, 2018, 09:28:55 AM by vera.bonda
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement