I am importing a Fixed Field .txt file into a SQL table.
One of the fields is 12 characters long begining with 2 alpha characters; 'AB1234567890'
However sometimes this can be 9 characters long of only numeric, preceded by blank spaces; ' 123456789'
This field is transfered to a field Varchar(12)
My DTS transformation copies the 12 character values, no problems,
but it omits the whole row where the value is 9 characters preceded by spaces, and doesn't produce an error.
I have tried all maner of Script conversions; Cstr, Trim, even replacing the spaces with bogus alpha-numeric characters.
I will probably have to write a script to import those few rows separately, but I'm curious to know why the error is happening in the first place.
![[hammer]](/data/assets/smilies/hammer.gif "[hammer] [hammer]")
Most appreciated if anyone can shed any light.
Remy
Hundreds of ways to do things with PC's, and learning new ways every day.
One of the fields is 12 characters long begining with 2 alpha characters; 'AB1234567890'
However sometimes this can be 9 characters long of only numeric, preceded by blank spaces; ' 123456789'
This field is transfered to a field Varchar(12)
My DTS transformation copies the 12 character values, no problems,
but it omits the whole row where the value is 9 characters preceded by spaces, and doesn't produce an error.
I have tried all maner of Script conversions; Cstr, Trim, even replacing the spaces with bogus alpha-numeric characters.
I will probably have to write a script to import those few rows separately, but I'm curious to know why the error is happening in the first place.
Most appreciated if anyone can shed any light.
Remy
Hundreds of ways to do things with PC's, and learning new ways every day.