kev
Reputation: 7
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 run which will return a 0 or a 1. I would like to store that value in a ssis variable
Upvotes: 0
Views: 275
Answers (1)
Cilvic
Reputation: 3447
- 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
Upvotes: 1
Related Questions
- Passing query results to variable in SSIS
- SSIS Looping with Return Value from Stored Procedure
- How to map the output of the stored procedure to variable in SQL Task?
- SSIS return values from multiple procedures
- SSIS return value of Stored Procedure within an OLE DB Command
- SSIS: Retrieving result set using a stored procedure, stored in a variable, that requires input parameters
- Executing a SQL statement inside a stored procedure, how to store the result of that SQL statement into a variable for later use?
- Passing a value to T-SQL procedure and getting an output value from the procedure using execute sql task SSIS
- Pass SSIS variable to Process task
- Calling a Stored Procedure From SSIS