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 |
|
kpatnam
Starting Member
2 Posts |
 Posted - 2008-02-05 : 05:28:15
|
Hi,Is there any way to cal a stored procedure in DTS Package?If so Kindly let me know ASAP with a small example.Thanks in advance !Regards,kalyani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-05 : 05:49:52
|
| Yup. You can call them inside Execute SQL taskEXEC SPName ?,?,?where ?'s stands for parameters. this you need to map it in parameters tab (in order in which its defined in SP) |
 |
|
|
|
|
|
Abt Stored Procedure @ DTS