I've got a package in SSIS 2012 that has an Execute SQL task in the control flow level.

The SQL in question does an Upsert via the SQL merge statement. What I want to do, is return the count of records inserted and records updated (No deletes going on here to worry about). I'm using the output option to output the changed recs to a table variable. 

I've tried returning the values as: 

```
Select Count(*) as UpdateCount from @mergeOutput where Action = 'Update'

```

and

```
Select Count(*) as InsertCount from @mergeOutput where Action = 'Insert'

```

I've tried setting the resultset to both Single rowset and Full rowset, but i'm not seeing anything returned to the package variables I've set for them (intInsertcount and intUpdatecount).

What am I doing wrong?

Thanks.