Unanswered: SSIS DTS Wizard cant convert Oracle Data
I've got a show stopper where a single Column from an oracle table always throws the following error.
Oracle Connection tests fine. Straight table to table conversion. Preview data looks great. I've even tried creating the table with valid SQL Server data types due to the Oracle types not mapping. id. Date=DateTime, number=numeric(18,2), etc.. On the field in question, I have tried float, decimal, numeric, nvarchar. Nothing works!
Error 0xc0204018: DTS.Pipeline: The output column "TRBL_TCKT_IC" (15) must have a precision between 1 and 38.
And yes, I've tried setting the precision to 38. numeric(38), nvarchar(38)