DTSRun using xp_cmdshell

[seekwall]

Hi,

I am trying to run the following batch within SQL2000:

declare @cmd varchar(100)
set @cmd = 'dtsrun /s servername /u username /p password /n my_dts'
execute master.dbo.xp_cmdshell @cmd

And keep getting the following error message:

output DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)

Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts.hlp

Help context: 713


Can anyone tell me what it is I am doing wrong? I have run the DTSrun part as a batch file, and it works fine


Thanks

Paul

 

[tlbroadbent]

Executing DTSRun with xp_cmdshell causes it to run under the SQL Account. The SQL start account must have permissions to whatever files you are trying to access. If those files are available on a mapped drive, remembe that SQL Server doesn't see mapped drives. It runs under its own NT credentials. You may need to use UNC addressing. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.