How can I (in SSIS) put into variables something from SQL table or query?
asked Oct 23, 2009 at 09:49 AM in Default
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:
Result Set Page:
answered Oct 23, 2009 at 05:39 PM