Hi,

I'm trying to load a table from a dts job that selects all the records from
sybase table and imports it into an equivalent MS SQL 2000 table.

I have done this successfully for 16 tables.

However for one table I get the following error on insert:

Error at source for row number 19000.
Errors encountered for this task: 1
[DataDirect][ODBC Sybase Wire Protocol Driver]Numeric Overflow. Error in
column 48.

Note: That I have serveral column with datatype money that didnt have the
above issue. Also I just migrated the databases from 7.0 to 2000 and its
working in SQL 7.0 but not 2000.
I have checked the column definitions for the table and as far as I can
determine both the Sybase and MS table match. Column 48 is of money data
type. Any ideas causing the error?

Thanks!!

Hi

I doubt that it is on the SQL Server side that this error is occuring. The
Sybase driver is failing on the column, long before it reaches SQL Server. It
is failing on trying to bring the row/ column over.

You may want to take it up with Sybase.

Regards
Mike

"SQLCluster" wrote: