SSIS : Oracle As Datasource --&&> Issues With Numeric Datatype

Hello,

I have to develop a package to get some data from a 10g Oracle database and load it to a SQL Server 2005 database.

In my design I used Oracle Provider for OledDB as my source provider following Microsoft recommendations found here : http://msdn2.microsoft.com/en-us/library/bb332055.aspx

As I have to use a parametrized query against my Oracle database I create a variable with my query that I override at runtime with a script task to update the parameters values.

One of the return column is of numeric datatype.

To handle this known issue with Oracle sources I edited through the advanced editor my Oledb source component to manually correct the precision.

Everything works fine with one of my package.

So I repeat the whole process while designing an other one with the same purposes.

As for the previous one I first unit test every components and everything works. But when running the full package it raised an error code 0x80004005 Error while validating post executing phase of the component (sorry for the poor translation from french to english ...)

I open my dataflow where the component is and found no warnings or errors. I edited through the advanced editor my Oledb source component and found that there's an error on the precision scale of the numeric return column. The message warn me that the precision must be between 1 and 38.
I checked this column and in the "OLE DB Source output / External Columns" the precision is 0 though I previously manually corrected it.
I upadted again for a 18 precision as it is for this column in "OLE DB Source output / Output Columns".
But it never keeps my changes ......

I delete the component and recreate it to force the metadata to be updated but always the same thing, the precision scale for this column in the "OLE DB Source output / External Columns" never keeps my 18 value.

Does someone have any clues to help me ?

Thanks a lot.

Bertrand