sql server dts: BCP -R -- sql server dts

BCP -R

ravi sankar
11/21/2003 4:02:04 AM

sql server dts: 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

Re: BCP -R

Andrew J. Kelly
11/21/2003 8:58:44 AM

This was answered in another ng.

--

Andrew J. Kelly
SQL Server MVP

[quoted text, click to view]