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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-16 : 10:31:37
|
| Alex writes "I'm using DTS to import data into a SQL server thats an ecommerce site runs off. The package is called from an ASP script as there are other tasks, that DTS cannot perform, that need to run before and after the import. I've got it working fine but when there are errors and the package execution fails the tranaction manager fails to rollback the data to its state at the begining of the package execution.I've selected 'Use Transactions' in the package properties and selected 'Rolback tranasction on failure' on all the workflows that allow it. I also have tranactions enabled on the ASP script.Thanks in advance for any assistance with this.SQL Server 7.0 with service pack 4 installed, running on Win2k server." |
|
|
|
|
|
DTS Tranactions