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 overridden method needs to have the User:id variable , which I'm not able to add to this object.

public override DTSExecResult Execute(Connections connections, VariableDispenser variableDispenser,

IDTSComponentEvents componentEvents, IDTSLogging log, object transaction)

Thanks!