I am having a problem 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. 8560.00
will show as 856.0000 in MSS2000.
Does anybody know why this is happening, or, where I can
get some information to solve this problem?

Thank you