Transactions

I've been creating DTS packages to automate several data transformation routines I need to do on my server. In most cases I'm importing data from access mdbs.

For one of the DTS packages, I need to delete data from 7 different tables and rather than create 7 seperate Execute SQL Tasks, I would rather write a transaction and call this in the DTS package. However, I have no idea how to do this? (sorry I'm a SQL server newbie)

I'm running SQL Server 200, please can someone tell me how I go about doing this

M3ckon

You can issue 7 delete from table X; in the same Execute SQL task

Thankyou, I've managed to get that working ... my next task is transferring 7 tables in access into SQL.

Again I know how to do this one at a time, but not for all 7 at once.

Can you help me on this???

(also can you tell me a good book I should get for SQL server 2000 or a decent web site)

M3ckon