March 13, 2002 at 5:42 pm
Hello,
I had the following working from an SP for quite some time however I had to reinstall SQL due to a disk failure and now it will not run:
EXEC master..xp_cmdshell 'DTSRUN /Fc:\PSP\tmpLoad.dts /NtmpLoad
In the output it returns Bad command or file name. It seems almost as though after the install of SQL it does not know about DTSRUN.
I ran the package from EM and it executes fine.
Any help would be appreciated.
Thanks,
Dan
March 13, 2002 at 5:49 pm
Actually baring the missing ' from the end (which I bet you have) this message is coming from the OS Command Prompt. Open a command prompt and type PATH. Make sure that the location of DTSRUN is in the path otherwise just typing DTSRUN will never invoke, you will have to use the full path 'C:\PROGRAM FILES\SQL\DTSRUN' whatever. You can add this in the environment variables of your server which will then when you type DTSRUN look at all PATHS for the existance of the executable.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 13, 2002 at 6:08 pm
Antares, looks like you hit it!
The path only had the windows directory.
When I added the path to my command line it worked as usual.
You folks have been very helpful and I appreciate it,
Dan
March 13, 2002 at 6:33 pm
I just enjoy a challenge. Glad to here that was it in one failed swoop.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply