Hi all,

When using the DTS Import wizard to import a text file with fixed width
columns, I can only set column breaks within the first 3461 positions.
The wizard will not mark anything after that point (I click at the
desired position and nothing happens). Also if i create one before at
the hightest point i can, then drag it higher, the column break returns
me back to the 1st position.

The file being imported contains data going up to character 4344. I
have 3 files in total that will exceed the 3461 limit. Here is an
example of the column structure I need to create.

COL1=CONTACT_POINT_ID,1,16
COL2=CONTACT_POINT_TYPE,17,30
COL3=STATUS,47,30
COL4=OWNER_TABLE_NAME,77,30
COL5=PARTY_ID,107,16
COL6=PRIMARY_FLAG,123,1
COL7=CREATION_DATE,124,20
COL8=EMAIL_FORMAT,144,30
COL9=EMAIL_ADDRESS,174,2000
COL10=PHONE_AREA_CODE,2174,10
COL11=PHONE_COUNTRY_CODE,2184,10
COL12=PHONE_NUMBER,2194,40
COL13=PHONE_EXTENSION,2234,20
COL14=PHONE_LINE_TYPE,2254,30
COL15=WEB_TYPE,2284,60
COL16=URL,2344,2000
COL17=RAW_PHONE_NUMBER,4344,60

The two numbers at the end represent the column starting position and
the length. If you look at the column 17 you can see i need to create
a column at position 4344.

NOTE - This file is not used in anyway in the import. I only refer to
it for column positions.

I am running SQL Server 2000 SP4 - under Windows XP Pro. I have tried
this import on SP3 and a non XP machine and it does the same.

Can anyone suggest anything I can do to get the data imported? As i
said, i have three files like this, the other two have more than one
column over the 3461 limit.

Kind regards,
D.

Did you ever resolve this problem? I am encountering the same issue trying to
load a file with over 5000 characters per record.

"Stark" wrote: