SQL Server Performance Forum – Threads Archive

DTS Audit reports

We are building DTS packages that will run in jobs and delete or insert records. I am looking for a way to include audit reports (when desired). In other words:
When the audit swith is on 1) Delete records
2) Print Deleted record report
3) Insert records
4) Print Insterted records report When the audit switch is off 1) Delete records
2) Insert records
If I remember right records are only marked delete until work is committed. So I think we need to somehow turn autocommiit off run the delete, execute are select against "deleted" items, then commit? I am very rusty but I remember there are some capabilites like that. Any help would be appreciated. TIA

---

]]>