I am experimenting with the Execute SQL Task. I have written an sql statement to select a single results set. The task runs fine. My question is: how do I see the record that was selected. In other words how do I capture this results set for further processing, such as inserting it into another table?

Thanks.
Samuel

I wrote a SQL statement that included "For XML Path('')" so that it would produce XML. In the General properties section I set the ResultSet property to XML. in the Result Set property section, I set the created a user variable to store that XML. I added a Script task to write the variable value to a file.