SQL Server Performance

Another Locking Question

Discussion in 'SQL Server DTS-Related Questions' started by dwilson, Aug 6, 2003.

  1. dwilson New Member

    Hi All

    I'm kinda new to DTS. I have a package that consists of a couple tasks that involve a particular table. I don't want the table's contents to change during the execution of the package. How do I implement a lock on the table for the duration of the package, and have all the relevant tasks in the package have access to the table.
  2. Argyle New Member

    If you want your entire package to work as one big transaction right click on an empty area in your package and select package properties. Go to "Advanced" and select transaction level (for example serializable) and check the option "Commit on succesful package completion"

    /Argyle
  3. gaurav_bindlish New Member

    If you are using a query to read the data, you can also use the Holdlock hint in the query.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  4. dwilson New Member

    Thanks for your suggestions guys.

Share This Page