DTS Package Issues with Access

Hello,

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

DTS jet oledb:engine type

What does jet oledb:engine type = 35 mean? I believe it means Excel file.
Where can I get a list of all the engine types?
Tnx in advance
JoeHave a look at this
http://support.microsoft.com/default.aspx?scid=KB;EN-US;230501
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||Thanks Allan:
We are close...look here:
http://www.thecoffeeplace.com/om/aaaaaagl.html
This is a list and it talks about values of 10,11,12...70
But not 35. The page you gave me only has 1-5 which the I listed above also
has 1-5, but not 35?!
Am I missing something in reading the page you gave me...?
tnx
Joe
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:VA.00000044.0158986e@.no-spam.sqldts.com...
> Have a look at this
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;230501
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>

DTS issue

In Microsoft SQL DTS I'm trying to run a package that convert output to a excel spreadsheet. Following error appears:
Error source: Microsoft Jet Database Engine
Error Description: Failure Creating File. What has added to my frustrations is, once I go to the server and open up the DTS package and click on destination it allows me to create new table, but that is only temporary. If I run a schedule job at a later time it fails again with the above message.Well if you're doing a CREATE, have you added the DROP?|||Brett, thanks for your reponse. It's only creating a dynamic table through DTS. When I take a look at the tables list it does not exist.|||Take a look at this post -> should answer your question.

http://www.dbforums.com/showthread.php?threadid=981661

kbk