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 |
|
jzeiger
Starting Member
1 Post |
 Posted - 2003-02-02 : 11:21:03
|
| Is there a facility in SQL 7 to monitor the execution of scheduled DTS packages?Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-02 : 12:06:21
|
| When you execute a package manually you'll get some status messages for each step being executed. But if you want specialized error handling or status logging you'd need to program that into the package itself, using OnFailure, OnSuccess and OnCompletion workflows. For instance, you can create a table to track progress and have each step run an OnSuccess workflow connected to an ExecuteSQL task that inserts a new row for each successfully completed step. |
 |
|
|
|
|
|
Monitoring DTS package execution (version 7)