SQL Server Performance Forum – Threads Archive
Another Locking QuestionHi 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.
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
If you are using a query to read the data, you can also use the Holdlock hint in the query. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Thanks for your suggestions guys.