DTS package error log | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS package error log

My DTS package failed and I got the following in my DTS log. <br /><font color="red"><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:The process cannot access the file because it is being used by another process.<br /> (Microsoft Data Transformation Services (DTS) Package (80070020): Cannot open a log file of specified name. The process cannot access the file because it is being used by another process.<br />)<br />Step Error code: 80070020<br />Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp<br />Step Error Help Context ID:1100<br /></font id="red"><br />What it means ‘because it is being used by another process’? Is it another process in SQL Server or another process in Windows? How can I get more detail info about the cause?<br /><br />CanadaDBA
May be you are runnig a job witch restrict access.
Somethink like DBCC CHECKDB REPAIR_REBUILD. In that case you have to modify database properties to restrict access. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
What is the purpose of this DTS package, is it an import or export?
Ensure the account used to execute the package has required privileges on the SQL Server and specified file path. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>