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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-12 : 08:12:10
|
| shoby writes "I created DTS package where I transform data from text file and put it in sql server staging tables. The package is scheduled to run everyday at 12:00 am. Clients have some specific requirements that I don't know how to solve. I got till scheduling and sending notification if the job fails. others are: 4. Success requirements: • Send only one email that expresses success for entire 4-table process. 5. Failure requirements: o Terminate all further processing of staging tables o Restore all staging tables back to original condition for consistency (not sure but is this the option in workflow properties- rollback transaction on failure???)• Send failure notification to NT event viewer • Send failure email. Include as much information as possible in the body of the email, such as: o Procedure name o Error number o Error description o SQL statement that failed o How to recover from the failure Thanks in advance" |
|
|
|
|
|
DTS Package error notification