I am importing some large text files into a database (Too
many to do manually), using a DTS package.

Each row has a varying number of columns, but it is only
the first 30 I am interested in, which are uniform.

Therefore, I am only importing columns 1 - 30 and ignoring
everything else.

Everything works fine, except that every so often
the 'extra' columns cause a row to exceed the 8kb maximun
row length of SQL server, and the DTS package fails.

Is there any way of getting around this? I just want the
DTS package to assume that culumn 30 is the end of the
row..

Thanks

NH

Hi,

I tried to replicate the issue that you are facing and my observations are
:-

1. The DTS error for exceeding row length is thrown for the 30 columns that
you are importing. DTS ignores the size of the columns that you never
import.

2. If both the datastructure and the data that you are trying to import are
larger than 8K then you get this error msg. Eg
I created a 2 column table where datatype was varchar(8000) for both
the columns. SQL creates the two columns.
While importing data, if the total row size is within 8K then DTS
imports the data successfully. If the row size is beyond 8K then the error
message is thrown.

Similarly, I created a table with 2 Varchar columns where the column
size was 3000 and 5039 resp.
I tried to import the same data (where the row size for some row was
exceeding 8K). DTS truncated the data and successgully imported the data in
the SQL server.


So please verify that the length of the data within the 30 columns is not
exceeding 8K size.


HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.