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
