Fixing Precision on Oracle Number Columns in SSIS

In SSIS I have a Data Flow that looks like the following:



To change the numeric data type precision I did the following.

1. Ensure the destination (DST_OLEDB Extract did_ms_contracts_v) has the desired precision
2. Change the properties on the data source to ValidateExternalMetadata = False
3. Open Advanced Editor on the data source
4. Change the precision of the desired columns in OLE DB Source Output – External and Output columns  (Might be able to get away with Output only, but I have not tested that)
5. Close the editor
6. Reopen the Advance Editor on the data source
7. Choose Yes to fix errors
8. Check the Error Output for proper precision on Columns
9. Close the window
10. Verify metadata on Data Flow path as it travels towards the data destination

This seems to be the magic formula.