DTS job failing execution when scheduled, works fine manually.

My DTS Package work fine if I Execute it manually, but I need to do it automatically just after midnight. I defined my schedule and made sure the job was present in the SQL Server Agent>Jobs, but it fails and the Job History shows the following error:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 1901 (76D) Error string: [Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

Help!!!Whenever I've had these types of issues, they had to do with the sqlserveragent not having permissions to a particular resource. You might want to start looking in that direction.|||I guess you are tired of getting up at midnight :-)

Does this help at all?PRB: Need to Map to Default Admin Account and Use NULL for Password In Order to Query Linked Server to Access Database.

Terri|||I figured it out, I was using a mapped drive and apparently NT Services do not recognize them. I used the UNC path in my DSN connection and all is well.

Thanks for the replies.