I am having extreme difficulty getting any a DTS package to run under
xp_cmdshell.

NOTE: I do have permission to run xp_cmdshell.

The package loads a file to the server, and then some manipulation tasks.
Running under Enterprise Manager, the tasks works every time, however,
running under xp_cmdshell fails every time and the errors returned are:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_14
DTSRun OnError: DTSStep_DTSDataPumpTask_14, Error = -2147217887 (80040E21)
Error string: Error opening datafile: Access is denied.

Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0

Error Detail Records:

Error: 5 (5); Provider Error: 5 (5)
Error string: Error opening datafile: Access is denied.

Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0

DTSRun OnFinish: DTSStep_DTSDataPumpTask_14
DTSRun: Package execution complete.

I have scoured the network in a attempt to discover WHAT USER needs to be
given permission on the file in question, on the PC in question. Someone
please help, I am migrating VB 5 applications to DTS, Stored Procs, and ASP
to make my life easier, but SqlServer is thwarting my attempts at the final
connection to the ASP front-ends.

Out network uses a Domain.

If you respond, please include my email address.

Andrew