Hello Guys,

Thanks for your all the post. They have been really helpful.

Robert, your last post helped to understand how we can configure the Variable But for me it didn't made clear how can i pass the SSIS variable to the stored procedure.

I have a EXEC SQL TASK and i am doing "EXEC Populate_something" in the sql statement of it. Now the question arrise is how should i pass that user::variable

Look forward for your help.

Regards

Sandesh