Thread: Transactions

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Sheffield UK
    Posts
    69
    Rep Power
    12

    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
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    You can issue 7 delete from table X; in the same Execute SQL task
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Sheffield UK
    Posts
    69
    Rep Power
    12
    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

IMN logo majestic logo threadwatch logo seochat tools logo