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 |
|
richardps
Starting Member
33 Posts |
 Posted - 2007-04-19 : 04:40:09
|
| Hi,What happens if my DTS fails half way through? (For example due to a network error).I guess what I'm really asking is: does DTS Wizard operate within a transaction which upon failure is rolled back, and on success is committed?Thanks,Richard. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-19 : 12:17:26
|
| I think so. The transaction is rolled back if there are any errors.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-20 : 14:55:02
|
| I think you can specify if you want it to run within a transaction. I'm pretty sure that is set by default. |
|
|
|
|
|
|
DTS Import/Export Wizard