Hello!
We have an SSIS package that simply copies a table from an Access database (located on network) to a SQL table. The package runs successfully if executed in Visual Studio. When a job is scheduled to run the package, however, we receive the following error:
Source: Package Connection manager "all" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file '\\IP_ADDRESS\LOCATION\\al
The folder the database is in has full permissions granted to everyone. Also, no one should be in the file.
Any help is appreciated. Thanks!
John
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Just replace this line on that KB:
The account that Microsoft Internet Information Server (IIS) is using (which is usually IUSR) does not have the correct Windows NT permissions for a file-based database or for the folder that contains the file.
With this line:
The account that Microsoft SQL Server Agent is using (which is usually Local\System) does not have the correct Windows NT permissions for a file-based database or for the folder that contains the file.
Thanks for the help!
We ended up creating a new Proxy account with Credentials. This seemed to fix the problem. Thanks again!
http://support.microsoft.c
http://msdn.microsoft.com/
http://msdn.microsoft.com/
John
Business Accounts
Answer for Membership
by: puppydogbuddyPosted on 2009-09-01 at 17:12:25ID: 25237294
see this link:
http://support.microsoft.c
several possible causes and remedies for the error message you are getting are discussed.