SEO

#1 (**permalink**) 02-29-2008, 03:35 AM

Hi Everyone,

I tried to bcp in the data file to a table in sqlserver 2000.
The data file has got few blanks in certain columns.
My requirement is all those blanks has to be converted null while bcp
in the data.

1. I have tried giving the option -k - Didn't work
2. I have tried creating a format file with prefix length 2 i.e as the
column is character.
3. Initially it was giving string data truncation error due to the
service pack3. Then I updated the service pack 3 also.

Pls someone help me out as this is very critical.

Thanks,
Ganesh

#2 (**permalink**) 02-29-2008, 03:36 AM

Hi

An empty string is not the same as a null value. The -k option will not help
you with that. If you want to ignore the whole column then you can use the
format file to ignore the column. If you want to change these values after
loading use a subsequent update statement.

John

"Ganesh Babu" <ganesh.kaliaperumal@wipro.com> wrote in message
news:35f45fe8.0407130502.37f14ad0@posting.google.c om...
> Hi Everyone,
>
> I tried to bcp in the data file to a table in sqlserver 2000.
> The data file has got few blanks in certain columns.
> My requirement is all those blanks has to be converted null while bcp
> in the data.
>
> 1. I have tried giving the option -k - Didn't work
> 2. I have tried creating a format file with prefix length 2 i.e as the
> column is character.
> 3. Initially it was giving string data truncation error due to the
> service pack3. Then I updated the service pack 3 also.
>
> Pls someone help me out as this is very critical.
>
> Thanks,
> Ganesh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

BCP -k option - Very urgent