hi the problem 4 is solved can say coz wt m doing is m assigning the query result to string variable1.

Then m taking OLE DB Source & mode of accessing...

hi thnx 4 the reply

i was using union all coz i wann the look up result as left outer...

Hey my Issue has been solved!!!!

it was silly mistake............i was passing the paramaters in OLEDB COMMAND TRANSFORMATION In wrong sequence.

I given the...

hello thnx for the reply..............

I hv tried ur solution But the thing is there mismaching in the...

I hv use the cast like below:

Select cast(max(record)as number(12,1)) from target

here i declare the variable to double.thn only its giving the same error.:(

yeah i have declare the variable as int32