Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Running DTS through xp_cmdshell and stored procudure... file permissions.
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 17th August 19:24
andrew
External User
 
Posts: 1
Default Running DTS through xp_cmdshell and stored procudure... file permissions.


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_DT***ecuteSQLTask_1
DTSRun OnFinish: DTSStep_DT***ecuteSQLTask_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
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666