How can I (in SSIS) put into variables something from SQL table or 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:
SQLStatement = SELECT COUNT(*) AS MyUserCount FROM users
ResultSet = Single row
Result Set Page:
Result Name = MyUserCount
Variable Name = User::UserCount
No one has followed this question yet.