Hi,

I am getting the following error when running a DTS package. The error
is coming when executing the COPY SQL Server Objects task.

ERROR DESCRIPTION:

Step 'DTSStep_DTSTransferObjectsTask_4' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The process cannot access the file because it is
being used by another process.
(Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on
'BNGWIP-D-9895.RLA_OPICA.DP1'. The process cannot access the file
because it is being used by another process.
)
Step Error code: 80070020
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

On further investigation on the error message, I found that the problem
is created because of temporary files created on the directory
specified for Exception logs. I deleted the temporary files and then
the task executes successfully.

Please let me know how to avoid this problem of temporary files not
getting removed. Also any possible ways for deleting the files before
the task gets executed.

Regards,
Pradip