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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2005-06-17 : 16:29:26
|
| I want to run a select stored procedure and insert into the destination table.Here the source I have a sp called usp_core_process which has a input parameter @process_id and I want to pass the process_id from another table to the stored procedure.So I have a execute SQL task which says select process_id from table1.Now I need to pass these process_id to @process_id so that it executes in the source table and obtains the required values and then inserts into the destination table.PLease help me with this |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-06-17 : 16:33:08
|
| Should I assign the each select process_id to a global variable to pass it to the stored procedure parameter |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-06-17 : 19:24:32
|
| Somebody please have a look at this |
|
|
|
|
|
|
Parameter passing in DTS