The oracle query table structure you need..?vineesh1701

Hi All, I have a oracle query ...which I have used in ssis oledb source...In oracle(SQLPlus) the query is executed fine....But when I am placing it in oledb source using oracle connection manager ...The query is parsing correctly but when I click columns its showing precision error ( Like precision value should be from 1 to 38 like that )....and this error is on float type columns....except these columns all are coming in the incoming data flow...I am not getting any idea how to fix this kind of issue... I have executed this oracle query in oracle database and its working fine there..... Does anyone faced this kind of issue... any options/alternatives could be helpful... vineesh1701

you can right click on OLEDB Source, select Advanced Editor, and then go to input and output columns tab, under output columns, select the column which you got data type problem and change data type or precision property of it. http://www.rad.pasfu.com

can you post the query and table structure?http://sqlworkday.blogspot.com/

Hi, The Precision and Scale are in disabled state ..for that Columns...How can I proceed..? Thanks,vineesh1701

I'm not fit in Oracle but it seems that SSIS can't work with the datatype. I suggest there is a chance to convert the values to a datatype which SSIS can work with. Something like Select cast(value as decimal (13,2)) from Oracletable