none
The data value cannot be converted for reasons other than sign mismatch or data overflow RRS feed

  • Question

  • Hi,

    In my package, I am loading data from SQL Server to Oracle. The table structure is almost same except the thing that, one field is integer type in SQL server and that same field is 'number' type in Oracle. So, SSIS assigns 'DT_I8' for SQL field and 'DT_R8' for Oracle field.

    Now, when I do insert to Oracle table using 'OLE DB Destination', it works without any problem. But when I update the Oracle table using 'OLE DB Command', I got the error 'The data value cannot be converted for reasons other than sign mismatch or data overflow'.

    After explicitly converting the data type to DT_R8 from DT_I8, it worked. My question is, why I am getting this error in 'OLE DB Command', but not in 'OLE DB Destination'?

    Thanks.

    Thursday, June 1, 2006 3:46 PM