August 19, 2003 at 9:44 am
Hello!
I am having a problem with DTS, when importing data from a table in a
SYBASE database to Microsoft SQL Server 2000 (MSS2000).
First of all, I created an empty table in MSS2000 with the
same column names and data types as the one residing in
SYBASE. Next, I used DTS to transfer the data.
The problem lies on the columns that have data of
type "money" - all zeros are being truncated i.e. 27200.00
will show as 272.0000 in MSS2000.
Anybody know how to solve this problem?
August 20, 2003 at 4:32 am
try doing an activex transformation on the columns
set
DTSDestination("DestinationColumn") = CCur(DTSSource("SourceColumn"))
January 23, 2004 at 10:39 am
I am having the exact same problem. I tried the solution suggested but it doesn't work with null data. Interestingly, another employee here can go through the same process as I, and does NOT have the problem. I haven't been able to identify any differences between what his configuration and mine.
January 23, 2004 at 10:53 am
I added logic to only use CCur on none null columns and I still have the problem
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply