SSIS 'Execute SQL Task' - multiple row result set to load into variables

Demonstration of calling "Execute SQL Task" to load some SSIS variables from a multiple row result set.

[rohanbarrett]

Very nice video; this is exactly what I was looking for to complete one of our projects at work.

[paulocuellas]

That is a very clear explanation! I can expand this example to the solution I need. Thank you very much!

[sumanthreddy]

good video but my source is pipe delimited.CSV file, how should I capture one entire column values into a variable and loop them inside DFT. Execute SQL task does not have .csv connection type, please help me with this

[SimonJones]

Quick question if you have chance; are there any other ways to achieve this?