Run Batch file from SQL

Hi

I'm trying to run a batch file from a SQL Script but error occurs.

Script:

Error:
output
operable program or batch file.
NULL
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IT EngineerCommented:
Try

since you have space in path, you must use "

or if this will not work change spaces for %20

Author Commented:
hi error, using %20

: output
The system cannot find the path specified.
NULL
Author Commented:
moved bat file to folder with no spaces in name

Experts Exchange Solution brought to you by

EXEC xp_CMDShell ' "C:\Users\Simon\Desktop\Stadium\Stadium Insert\Integration Services Project7\refresh.bat" '