I kick off a DTS package with ASP.NET. I'm getting an error stating:
The Microsoft Jet database engine cannot open the file <path>. It is already opened exclusively by another user, or you need permission to view its data.
The DTS package is pushing data from Excel to Access, and then Access to SQL. When running the process, I run it directly and it works fine. I haven't tested it through scheduling yet. All of the information on the web says security permissions, but I impersonate the ASP.NET page to use another account, which has full access to the access database and dbo to SQL Server.
Any ideas?
Brianmake sure the files are closed. If the excel file is open it will not work|||Hey,
It was. And I make sure that the data pump tasks closed the connection on completion, through the Workflow Properties screen.
Brian
No comments:
Post a Comment