Sorry for my poor language knowlegde. Let me try to clarify my point once again.

I have declared a Variable within SSIS. By executing an SQL task, I want to...

Thanks, Marc.

Using a script component should be possible I think. But my plan is actually to get this done without using scripts, as Microsoft claims that almost all transformations can...