Hi,
I'm trying to load a CSV file into SQL Server 2000 database table. I'm using
Microsoft Text-Treiber provider to load CSV. It works fine except that when
it encounters a scientific notation number (2.554E+6) on CSV file it loads
it in SQL Server as just 2 (first digit) and truncates everything after the
dot. I tried to change destination column datatype to all possible numeric
formats (number, money, decimal, float....) and it doesn't work...

Any idea on how to let DTS know that it's a large number in scientific
format and it should treat it as a 2,554,000 not just 2 ?

Thanks!