
November 11th, 2003, 11:40 AM
|
|
Contributing User
|
|
Join Date: Nov 2003
Location: Sheffield UK
Posts: 69
Time spent in forums: 1 m 57 sec
Reputation Power: 10
|
|
|
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
|