'Invalid column number' when importing

[kim]

When I try to import a Pervasive table into SQL Server 2K, I get the error msg of 'Invalid column number'.

Is that because SQL Server cant handle more than 1024 columns ?

I think my Pervasive table has more than 2000 columns

Thanks in advance

[MAK]

I guess so.

did you try mapping using DTS transofrmation?

[MAK]

Tables with 2000 column is a poor design, you can redesign the architecture in sql.

[kim]

yes,I tried in DTS...and yes, I agree a table that has 2K columns is a bad design...but unfortunately I was not involved in that process. But I do need to retrieve all the data from those 2K columns.

I was thinking of writing a SQL query that calls out 1000 columns in one statement and 1000 columns in the second....is there anything easier ?

Thanks

[MAK]

this is the way to go.

[skhanal]

When you split the table into multiple tables, try putting columns which actually has values into one table and columns with predominantly null values into another.
If all columns in the second table is blank you may not need to insert a record.