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 |
|
bpgupta
Yak Posting Veteran
75 Posts |
 Posted - 2007-08-31 : 07:46:02
|
| HI,IS any body used the dynamic parameter for Stored Proc in DTS.I knew it can be done ,but not getting the right string to do it.Thanks,BPG |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-31 : 11:34:06
|
| What do you mean by dynamic parameter? Can you explain some more details on what you are trying to do?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-08-31 : 12:49:14
|
Are you trying to execute a stored proc from an execute sql task mapping global variables to parameters? I.e. EXEC dbo.usp_myproc ?, ? Mark |
|
|
|
|
|
|
Dynamic parameter in DTS Task