MS SQL Server DTS - DTS Import - Fixed width column break problem

Author

DTS Import - Fixed width column break problem

Stark

2006-03-21, 7:27 am

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_I
D,1,16
COL2=CONTACT_POINT_T
YPE,17,30
COL3=STATUS,47,30
COL4=OWNER_TABLE_NAM
E,77,30
COL5=PARTY_ID,107,16

COL6=PRIMARY_FLAG,12
3,1
COL7=CREATION_DATE,1
24,20
COL8=EMAIL_FORMAT,14
4,30
COL9=EMAIL_ADDRESS,1
74,2000
COL10=PHONE_AREA_COD
E,2174,10
COL11=PHONE_COUNTRY_
CODE,2184,10
COL12=PHONE_NUMBER,2
194,40
COL13=PHONE_EXTENSIO
N,2234,20
COL14=PHONE_LINE_TYP
E,2254,30
COL15=WEB_TYPE,2284,
60
COL16=URL,2344,2000
COL17=RAW_PHONE_NUMB
ER,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.

2006-04-06, 11:30 am

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:

> 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_I
D,1,16
> COL2=CONTACT_POINT_T
YPE,17,30
> COL3=STATUS,47,30
> COL4=OWNER_TABLE_NAM
E,77,30
> COL5=PARTY_ID,107,16

> COL6=PRIMARY_FLAG,12
3,1
> COL7=CREATION_DATE,1
24,20
> COL8=EMAIL_FORMAT,14
4,30
> COL9=EMAIL_ADDRESS,1
74,2000
> COL10=PHONE_AREA_COD
E,2174,10
> COL11=PHONE_COUNTRY_
CODE,2184,10
> COL12=PHONE_NUMBER,2
194,40
> COL13=PHONE_EXTENSIO
N,2234,20
> COL14=PHONE_LINE_TYP
E,2254,30
> COL15=WEB_TYPE,2284,
60
> COL16=URL,2344,2000
> COL17=RAW_PHONE_NUMB
ER,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.
>
>

Sponsored Links