sql server dts: We have a DTS package that runs twice a day. this package gathers data from an AS400, FoxPro for DOS, and 2 other sql server instances and the data is used for reporting purposes through Crystal Reports.

If a report is requested with invalid parameters, a Lock Mode of IS (Shared Intent) is made and remains on the corresponding table. When the DTS starts it attempts to make a lock of IX (Exlcusive Intent). This blocks the DTS package from completeing. Is there some steps to determine if 1.) A process has any kind of lock on a resource in a given database, and then kill the process? I want to add a step at the begining of the DTS package to have this done to insure the package executes correctly. The package takes about 3 minutes to complete.

You could get the info from syslockinfo then issue a KILL to the
req_spid....
Cheers,
Paul Ibison