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 |
|
MarkyBoy666
Starting Member
14 Posts |
 Posted - 2005-04-20 : 10:28:48
|
| Hi,I'd like to add an On Fail workflow to a step in my DTS Package, and then execute a Send Mail task on such a failure.The problem is, I don't know how to dynamically insert the details of that error into the mail message - does anyone know?Many, many thanks! |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-20 : 13:45:16
|
| Do a search in BOL for 'send mail'. Open the result for 'Send Mail Task Properties'. Is this what you needed? |
 |
|
|
MarkyBoy666
Starting Member
14 Posts |
Posted - 2005-04-25 : 07:08:20
|
| That's what I'm after, thank you |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-04-25 : 10:29:17
|
| Just a follow-up question on this topic.Send Mail Task is better or Using an ActiveX Script with CDO is better?Karunakaran___________NOTHING IS IMPOSSIBLE, IMPOSSIBLE JUST TAKES LONGER... |
|
|
|
|
|
|
DTS Send Mail Task - using it to report errors