470,811 Members | 1,323 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,811 developers. It's quick & easy.

Is there a way to allow aspnet_wp.exe to execute a DTS Package that can be executed from a Windows Form application?

I have a Windows library that I bind into a Windows Form application and
into an ASP.NET Web Application. I have a procedure in the library that
executes a DTS Package. I have also used information from Knowledge Base
article 306158, INFO: Implementing Impersonation in an ASP.NET Application
to create a procedure to perform impersonation.

When I try to execute the DTS Package from ASP.NET, I get the following

Step 'DTSStep_DTSTransferObjectsTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Access is denied.
(Microsoft Data Transformation Services (DTS) Package (80070005): Access is
(Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on
'IFSERVER.RCIA.LOG'. Access is denied.)
Step Error code: 80070005

But when I call the same steps from a Windows Form application, the DTS
Package executes and there is no error.

I run IIS on an Active Directory Domain Controller, so I have setup a Domain
account called ASPUSER and set this account up as recommended in Knowledge
Base article 315158, FIX: ASP.NET Does Not Work with the Default ASPNET
Account on a Domain Controller.

When I have run the Windows Form application to successfully execute the DTS
Package, I have been logged on using my Domain Administrator account and I
have impersonated the ASPUSER Domain account. Both of these approaches
worked with no errors and the DTS Package executed successfully.

I have run the ASP.NET application using the ASPUSER Domain account and I
have impersonated the Domain Administrator account and both of these
approached have resulted in the error shown above.

The ASP.NET error is encountered whether I turn logging on or off in the DTS

This behavior leads me to think the aspnet_wp.exe program is being treated
differently than my Windows Form application, but I cannot find a way to
change the settings in a way that let's me successfully execute the DTS

If anyone has suggestions about what I can do to resolve this problem, I
would greatly appreciate the help.

Nov 17 '05 #1
1 2054

You are in the right direction. ASP.NET default user has limited rights
and he canít activate other processes. You need to change the asp.net
user to one with right permissions. Just to prove my point use the
identity tag with user name and password of administrator JUST TO CHECK
AND THEN TO REMOVE!!! . I successfully run DTS this way, but Iím in
internal close intranet environment where the users arenít threat to the

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Chris | last post: by
4 posts views Thread by Lynn | last post: by
3 posts views Thread by Ingo Lundberg | last post: by
1 post views Thread by rAinDeEr | last post: by
4 posts views Thread by =?Utf-8?B?TEJU?= | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.