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 |
|
dhani
Posting Yak Master
132 Posts |
 Posted - 2008-10-15 : 19:45:03
|
| Hello All,as per the user requirement, in my solution (it has 14 data flows basically reads data from another sql server and loads to staging db sql server)now if the package fails then the staging db needs to be clearedcan any one please let me know, how can i achieve this (how to create such kind of event(like when package fails) and also how to clean DB)Thanks in advanceasini |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-16 : 07:16:27
|
| Under Event Handlers tab > Event Handler = OnError, add a SQL Execute Task to do your table clean up. Make sure under Executable it's selected at package level.You can also add Mail Task to notify when package fails. |
 |
|
|
dhani
Posting Yak Master
132 Posts |
Posted - 2008-10-17 : 10:49:35
|
Thank you rgombina,it is working fine, and also i added execute sql task to clean up database tables (if package fails)once again thank you very much rgombinaRegardsasinquote:
Originally posted by rgombina
Under Event Handlers tab > Event Handler = OnError, add a SQL Execute Task to do your table clean up. Make sure under Executable it's selected at package level.You can also add Mail Task to notify when package fails.
|
|
|
|
|
|
|
how to set event on package failure