Prob Running Batch file from xp_cmdshell

[SSesham]

declare @client varchar(25), @outputfilename varchar(30)

SET @client = 'MYCLIENT'
SET @outputfilename = @client + '.txt'

declare @cmd varchar(255)

set @cmd = 'C:\Database\Disease_Registry\Common\ReleaseP4PandDR\TrimSpaces.bat ' + @outputfilename

exec master..xp_cmdshell @cmd

This code is returning "The system cannot find the specified path"..BUT when i extract the @cmd variable and run it from command prompt it works fine. is there a special way of running a batch file from the Xp_cmdshell?
thank you very much for your time in advance.

 

[ESquared]

Does your output file have spaces in it? Try putting double quotes around it in your script.

 

[mrdenny]

Are you sure that the listed file exists on the SQL Server? Does it work when you run it from the command line on the SQL Server or your workstation?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SSesham]

sorry, placing double quotes does not do anything.

the text file has spaces and i'm trucating it with a cscript and vbs file..which i placed in a batch file.no i need to run the batch file with a parameter from xp_cmdshell .

the command i'm running to get this output text file is

C:\Database\Disease_Registry\Common\ReleaseP4PandDR>osql -E -S server5 -d myDB -s "," -h-1 -n -w 100 -i input.sql -o output.txt

 

[SSesham]

Yes! it runs fine when i run the value in @cmd from the command window. its confusing why it wont work from a xp_cmdshell when the string is correct!!