RE: Numeric Overflow of Column of datatype Money
- From: "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 00:55:04 -0700
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:
> 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!!
>
.
- References:
- Numeric Overflow of Column of datatype Money
- From: SQLCluster
- Numeric Overflow of Column of datatype Money
- Prev by Date: Re: sql server agent job step that runs a dts package fails - urge
- Next by Date: Re: A DTS step freezes (status is just "Executing Job Step 'job name'")
- Previous by thread: Numeric Overflow of Column of datatype Money
- Next by thread: Type Mismatch: DTSLookups?
- Index(es):
Relevant Pages
|
