Error when using an Oracle source

[RiverGuy]

Error 0xc02090f8: Data Flow Task 1: The value was too large to fit in the output column "AMOUNT" (58).
(SQL Server Import and Export Wizard)

SSIS 2008. I am using the .net data provider for Oracle. The column in Oracle is defined as NUMBER (no precision or scale specified). The largest value in the column in the source table is in the low millions. I don't see how it would overflow anything. If I look at the Data Flow Path Editor, the column is set to DT_NUMERIC(38,4).

Does anyone have any ideas?

Thanks

by the way, the Oracle version is 11g

 

[MDXer]

Yeah pulling oracle into SSIS is always a nightmare. Just as a test have you tried a float datatype?

Also try a datatype conversion task and see what you can convert it to.

 

[RiverGuy]

The error is when the data in the stream is being applied to the object type, so it will not even get to the point where a datatype conversion task would be applicable. And bringing up the advanced editor of the source query, it does not allow me to change the type of the external columns. My temporary workaround is to explicitly cast the column in the source query to DECIMAL(22,4).