> The problem is that in input files decimal point is written as "," and
> without leading zeros (i.e.: ",45"), and sever uses ".".
Try SSIS (or DTS) instead BULK INSERT so that you have the flexibility to
fix the data during the im****t process. If you must use BCP, you'll need
to
im****t into a staging table with the decimal column defined as
char/varchar
so that you can UPDATE the decimal value and INSERT into the target table.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
<KiP.Kolodziejczyk@[EMAIL PROTECTED]
> wrote in message
news:adba0123-d336-4477-bef5-522f29314dd1@[EMAIL PROTECTED]
>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...?
>
> Piotr
>
|
