Koen Verbeeck (2/11/2014)
The code is easier than you might think:I would store the result in an SSIS variable and populate a column in the data flow using a derived column and this variable.
That way you won't have to execute an additional Execute SQL Task.
I'm glad you posted this - I didn't have time. That's exactly how I would do it too.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.