Hi,

Thanks for the reply.

I cant change the first stored procedure to a user defined function because I am using some dynamic sql in that procedure which cant be achieved...

Hi Michael Earl ,

Thank you for the quick reply.

How we are going to achieve this using CLR procedure.

Is there any method/funtion available in CLR(SSIS) like "eval" to evaluate a string...