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

task.Execute(connections, variableDispenser, componentEvents, log, transaction);

I see that variableDispenser doesn't have User::id variable contained in it.

Ques : - How do I add variable to variableDispenser object. This object is coming from overridable execute function.

DTSExecResult Execute(Connections connections, VariableDispenser variableDispenser,

IDTSComponentEvents componentEvents, IDTSLogging log, object transaction)

Thanks!