Sorry I thought the variable you were using was in the SSIS package not an SQL variable.

I take it the SQL Task you have just does

SELECT COUNT(1) From myTable

After that you have the SQL task set to use the result set and pass the value back to an SSIS variable

is that correct?