>-----Original Message-----
>Hi all,
>
>I m trying to use BCP utility to upload a huge text
file.
>As per microsoft documentation, -R is used to specify
the
>regional settings. My computer (client) and the sql
server
>(running in a network machine) has dd/mm/yyyy as the
>regional settings. The incomming text file also has date
>in dd/mm/yyyy format. But when i execute BCP with -R
>option, i still get an invalid date format error
message.
>
>I went through a few microsoft support information, that
>told me that SP1 should solve this problem. I got SP3a
>installed (both in client and in the server).
>
>So what am i missing here??? I m sure some of u here
>should have also faced the problem. Any type of help is
>greatly appreciated.
>
>thanks and regards,
>s.ravi sankar
>
>.