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 |
|
SQLfriends
Starting Member
12 Posts |
 Posted - 2002-09-24 : 14:56:06
|
| I am working on a package in which it will run everyday, scan through a table to grab all the date and compare with execution date of the package. If those two dates match, the package will move on to do some more tasks. Otherwise, it will just quit.I wonder whether the "On Completion", "On Success" and "On Failure" events will take care of the situation. If not, are there any other better alternatives?Thanks. |
|
|
Crespo
85 Posts |
Posted - 2002-09-25 : 04:53:19
|
| I think you should use the 'ON SUCCESS' event as it will only execute the rest of your package if and only if the conditions are satisfied. The 'ON COMPLETION' event would trigger the rest of your package regardeless of whether the dates match or not.Good Luck!Crespo.Hewitt Bacon & WoodrowEpsomSurreyUnited Kingdom |
 |
|
|
|
|
|
DTS events