We are trying to extract data from an Oracle 10g db into SQL Server 2005 via SSIS. Number fields (1/0, null) are losing data when they arrive in the SQL db. 0's come through ok, but any other number ends up as NULL in the SQL db.
Strangely, this worked before we upgraded to a 64-bit operating system for SQL.
We are using the Data Reader source and ADO connection.
Anyone seen this and know how to fix it? I've tried various data conversions and, even though they are accepted by the SSIS task, the data ends up as just 0 and NULL.
Thanks.
'The world isn't round - it's bent!' Spike Milligan
Strangely, this worked before we upgraded to a 64-bit operating system for SQL.
We are using the Data Reader source and ADO connection.
Anyone seen this and know how to fix it? I've tried various data conversions and, even though they are accepted by the SSIS task, the data ends up as just 0 and NULL.
Thanks.
'The world isn't round - it's bent!' Spike Milligan