I want to capture the # of rows returned to an SSIS Variable in Execute SQL Task . As it is returning nothing I get an error in SSIS like...

true, I want sum(a) in the query that is why I'm using a group by there. Below is the exact query I'm trying.

select sum(a) from dbo.test group by b having...

Here b has "date" data type. Below is the query I tried. Still no result set.

select * from dbo.test group by b,a having b=CONVERT(date,getdate())

The above query returned when condition is...