Thanks ,

I tried this sample, but the issue here is when I try to add new variable to custom task - it doesnt work and throws error.

variableDispenser of this...

To add my further investigation, when I run this line of code to run query

task.Execute(connections, variableDispenser,...

Thanks , but this dint help.

I changed code as

<<<

Microsoft.SqlServer.Dts.Runtime.Variable variable = package.Variables.Add("id", false,...