(KiP.Kolodziejczyk@[EMAIL PROTECTED]
) writes:
> I 'd like to insert (via "bulk insert") between 10-20 files (about
> 300MB each) into one table.
> The problem is that in input files decimal point is written as "," and
> without leading zeros (i.e.: ",45"), and sever uses ".".
>
> So I 've got an "type mismatch" error.
> I can't re-build input file, as well as I can't change configuration
> of mssql sever.
> Is there any option to force the server to convert decimal point while
> im****ting?
> Maybe "file format" option in bulk insert, or another way of
> im****t...?
With BULK INSERT you are out of luck. With BCP, it is possible that the
-R option can help you. This option causes BCP to honour regional
settings.
You would need to have regional settings where , is the delimiter, but
if you are located in Poland, I guess you have.
I need to add the discalimer that I am not sure that this will work. I
have
had problems with the -R options to work in the past, as I recall. And
if you have a mix of decimal comma and decimal point, you really have a
problem.
--
Erland Sommarskog, SQL Server MVP, esquel@[EMAIL PROTECTED]
Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
