I'm running into an issue trying to DTS data into SQL 2000 from a
legacy system using an NCR ODBC driver. The decimal places on the
numeric fields are truncating. The source data is defined as
decimal(15,2) in the source data. The table is created in the DTS
process and is defined as decimal 9(15,2). However, the decimal
values are truncated. I've tried creating the table and just
appending the rows...again I got the same issue. Anyone run into a
similiar situation and have a possible solution? Thanks.