There is no special locking placed by DTS. The locking is done based on servers isolation levels.
>Hello,
>
>I have created an SQL DTS package that transfers objects and data from one database to another.
>
>
>Does this process lock the source tables?
- Jayesh