1

I have a SSIS package with approximately fifty data flows in it that interacts with an Oracle database.

We changed data types in Oracle database for about 55 tables / 300+ columns from FLOAT to NUMBER (30, 15)

I am now working on changing the data types in the SSIS package.

Every time I change a column from FLOAT to NUMBER in a DATA CONVERSION component, it defaults to NUMBER (10, 0).

Is there a way for me to change this so that the default comes up as NUMBER (30, 15)?

Raj More
  • 47,048
  • 33
  • 131
  • 198

1 Answers1

1

I don't think that this is possible, you can save yourself a little bit of pain by using text expander / replacer program like Breevy: http://www.16software.com/breevy/

DKnight
  • 733
  • 3
  • 15