To verify the result set value : use one more execute sql task and write insert statement into one temp table, pass the parameter from the 1st sql execute task.