How can I (in SSIS) put into variables something from SQL table or query?
Jack Woo
asked
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
