Hi. I’m Wayne A Arthurton.

Here are some thoughts of mine.


Fixing Precision on Oracle Number Columns in SSIS

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

Fixing Precision on Oracle Number Columns in SSIS

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 ValideExternalMetadata
  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) Precision change
  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