When I run a package from under my ASP.net application, it fails.

The DTS package is trying to write the following file:
c:\usr\phx\dfeed\xyz.txt

Now the package runs just fine when run from the Enterprise Manager.

Surmising that the error may be due to the fact that when it runs under
ASP.net, it is running as the user ASP.NET on the system, I created a new
ASP.net application and had it create and write a file into that same
folder. So, it cannot be the ASP.net permissions.

I am not sure what the problem is. Any ideas?

The error log from the DTS package is shown below.

Thanks in advance,

William

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Step Error Description:Error opening datafile: Access is denied.

Step Error code: 80004005
Step Error Help FileTSFFile.hlp
Step Error Help Context ID:0