Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MIKEBIERCH
Starting Member
1 Post |
 Posted - 2009-10-15 : 15:14:12
|
| I have recently been experiencing a problem with DTS 2000 importing Excel data. The problem is occuring when DTS attempts to import an Excel column that is formatted as a Number that contains values less that 0.10.What is occurring is that the value is getting multiplied by 100! I can see it when I compare the original value in the Excel worksheet against the value displayed in the DTS preview of the data transformation task. For whatever reason values such as .049 are being transposed into 4.99.However, if I reformat the column as currency with a $, the data is importing correctly. If I format as currency without the $, the problem occurs.This happens both in DTS Package Designer and in old VB DTS Package code that hasn't been modified in years.Any idea what's going on??? |
|
|
|
|
|
DTS 2000 Excel Import Suddenly Multiplying Values