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 - 2006-01-12 : 08:42:57
|
| David writes "I have a stored procedure that inserts a record into a table and returns the @@Identity value. I have returned the value as an output parameter (version 1) and as a rowset (version 2).I need to capture this value inside a DTS package as a global variable. Ideally, it should be an integer as I intend to use it to insert child records into another table." |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Setting a DTS Global Variable to @@Identity 