I am using VC 5.1.6 and the SQL task. My SQL script (for an MSSQL DB) selects three sets of data in one script. i.e.
Print Set 1 Heading
Select Query 1
Print Set 2 Heading
Select Query 2
Print Set 3 Heading
Select Query 3
However, the Task Output Varibale only displays the "Select Query 1" output. It does not show the print headings nor the out puts from the other 2 select queries. Is there another way to output the full resuults? Or do I need to setup three tasks for this query?