-
'Invalid column number' when importing
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
-
I guess so.
did you try mapping using DTS transofrmation?
-
Tables with 2000 column is a poor design, you can redesign the architecture in sql.
-
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
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|