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 |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2009-03-17 : 06:30:28
|
| Hi GuysI have a SSIS package which has multiple stored procedure within it.Eg. SP1 --> SP2 --> SP3 --> SP4The thing that I am trying to achieve is when the stored procedure is running the package will store that name of the procedure within a variable which can then be passed through a failure email to the user.I know I could add separate email tasks to each stored procedure, but the package is likely to grow and the design could end up rather messy.Does anyone know if this is possible to do?Thanks |
|
|
|
|
|
Storing a SP Name in a Variable