开发者

Change sizing defaults for data types in SSIS

开发者 https://www.devze.com 2023-02-09 05:46 出处:网络
I have a SSIS package with approximately fifty data flows in it that interacts with an Oracle database.

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 wo开发者_运维百科rking 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)?


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/

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号