I'm in the process of setting up the SQL Sensor v2. However when the sensor is executed it returns with and error - "No valid datatable was returned".
If the SQL query used in the sensor is executed in SQL Managment studio it does return one row with a value.
The result set is as follows:
(No column name) run_status CopyBatchData 1