SSIS and Variables from SQL 2005 query

The easiest way to do this is by mapping the result set to variables. You can also map variables to parameters, but that is typically (but not always) used for passing variable values to the query.

Here's an example using the result set, let's say you have a variable User::UserCount.

Execute SQL Task:

General Page:

SQLStatement = SELECT COUNT(*) AS MyUserCount FROM users
ResultSet = Single row

Result Set Page:

Result Name = MyUserCount
Variable Name = User::UserCount