DT_DECIMAL Vs DT_NUMERIC

Hi,

I've had problems with DT_NUMERIC in the past, where it chops off numbers and rounds them before they get to the database, even if you specify the exact same "Data Precision" and "Scale" as are defined in the table.

So, I did some tests with DT_DECIMAL and found that this data type does not do this.

I am trying to understand why the DT_DECIMAL data type does not allow you to change the "Data Precision," but DT_NUMERIC does.

I need to be able to set it to the equivalent of numeric(38,12).

Thanks