|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
hi,
i have a stored proc that has output parameters and i want to save the output to a global variable. the query in the execute sql task looks like this exec mystoredproc ?,?,?,? where the 1st three are inputs from global variables and the fourth one is the output parameter which needs to show up. the output of the stored proc is a long string. when i execute the step, the package runs fine, but no value seems to be stored in the output global variable. could you please help me with this. any help is greatly appreciated. |
|
#2
|
|||
|
|||
|
First you can declare a global variable for receiving output value "@outval" . Next execute stored procedure with output parameter with "output" key word.
declare @outval as varchar(100) exec mystoredproc ?,?,?,@outval output print @outval Jefy |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Dts , stored proc with output parameters |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|