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-25 : 17:19:50
|
On the DTS design sheet, we manipulate task objects, connection objects and workflow. Is it possible to make the whole package as a transaction? If any of the tasks fails, the package will roll back to whatever it has done. Thanks. |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-25 : 19:01:04
|
As long as you don't individually commit a step or steps, then the entire package will execute as one transaction. Furthermore, you can set properties on the entire package, under the Logging tab, to fail the package on the first error...this should guarantee that the whole package has to succeed in order to commit.Take a look in this forum (Import/Export and Replication), someone had an identical question in the last few days that had more information on how to do it. |
|
|
|
|
|