SSIS: how to read the result of a stored procedure into a global variable or something useful
I have a stored procedure i want to ru开发者_如何转开发n which will return a 0 or a 1. I would like to store that value in a ssis variable
- use a dataflow task
- define the variable using the "variable" tab on the left hand side (next to the toolbox tab)
- use the "exectute sql task"
- in the properties of the sql task setup a result set
精彩评论