Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-18 : 17:56:57
|
| Rajesh writes "I have a SQL task where I execute a stored procedure with input and output parameter. Input parameter is working fine. For output parameter, I have specified Row Value option as I have finally a select statement in the Stored Procedure before return statement. I have defined "BEGIN, COMMIT and ROLLBACK TRANSACTION" in the stored procedure. Unless I give a dummy SELECT statement after "BEGIN TRANSACTION", the row value does not appear in that SQL task. The value of return variable changes inside the stored procedure. Before returning and after COMMIT or ROLLBACK TRANSACTION I have given the SELECT statement to get the value as output parameter. But is not getting that value. Through SQL Query Analyzer it works fine. What might be the problem? Is there any other option to work around?" |
|
|
|
|
|
Output parameter in DTS from stored procedure