I am not sure what else I can do...

The SQL Server has pemission to view and edit the database. which is located on a mapped drive R:\ No one else is using the database and the following error occurs when I start the job. Keep in mind I can Execute the package manually and it completes with success.


... DTSRun: Executing... DTSRun OnStart: Drop table Results Step DTSRun OnError: Drop table Results Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file 'R:\WebNTI.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 DTSRun OnFinish: Drop table Results Step DTSRu... Process Exit Code 2. The step failed.