I have a DTS package that is transforming various data from some Access databases. Up until recently, it has been running on the scheduler with no problems.
Now it is failing from Scheduler with error...
Step Error Source: Microsoft JET Database Engine
Step Error Description:Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Step Error code: 80040E4D
Step Error Help File:
Step Error Help Context ID:5003028
The databases are secured & the security file has been copied locally to the server & this is used to connect to the db's - all user & pwd info is set in the DTS connection design dialog.
I can still log on to the server & manually execute the package with no errors??
I've tried to edit the connection properties in DTS design (again, on the server), sometimes it will prompt me to remap transforms that use the connection but accept the info, other times it will chuck out above error & not let me OK the connection dialog.
The server is the only machine using the mdw file, so it's not a locking issue from other users. Why can I still execute the package manually, but ALWAYS fails from scheudle? Can't figure it out.....
Any advice appreciated.