November 11th, 2003, 11:40 AM
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
November 11th, 2003, 01:29 PM
You can issue 7 delete from table X; in the same Execute SQL task
November 12th, 2003, 03:34 AM
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)