Result Set Execute Sql Task Ssis. Hi I have an SSIS package with an Execute SQL Task and a Send Mail Task. On the Result Set tab.
Enter your SQL Statement. In SSIS 2008 I have an Execute SQL Task in a Foreach loop that will fetch one single result value from a table and puts it in a variable for File System Task. In this example we will use the SSIS Execute SQL Task full row set option to select the data present in the Employee table and save the returned result set in another table.
Click Result Set.
Double click on it and set the following properties. Hi I have an SSIS package with an Execute SQL Task and a Send Mail Task. So we need to go back to the General settings screen and in the Result Set section change the value of the ResultSet property to something other than None in order to be able to make changes to the ResultSet screen later. Set the ResultSet to Single row.