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 |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2003-07-25 : 11:41:25
|
| In SQL 7.0, we copy tables through a proprietary ODBC into SQL server and then copy them to another SQL server. The first step is to truncate the tables and then import the data. If the job fails, such as source server is unavailable, the tables are already truncated. Can I put a rollback transaction as a DTS step on failure and what would the syntax be? (Someone will probably suggest replication between SQL servers which we have had poor luck with.) Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 12:08:03
|
| bcp, isql, xp_cmdshell, rename table, create new tabel with old table nameI don't think TRUNCATE can be rolled back as it's a non logged opBrett8-) |
 |
|
|
|
|
|
Rollback in DTS