Thanks Brandie,

But here in our case we are not sure of the out put column names. Based on the parameters what we pass to the SP, the out put columns will be different. So in that case how do we approach this?

For example; I have 3 parameters say

@p1 -- this can have values Month or Qtr or Year

@p2 -- this can have values Income

So based on the parameters we pass to the SP ( which is used in the OLEDB Source ) the output columns can be either Income_Month OR Income_Qtr OR Income_Year based on the value we passed for @p1