Software

Question

Gravatar
0 Votes
Locked

MSSQL - 'DTSRun' is not recognized as an internal or external command

By zerosentiment ·
I have a script that uses a bat file to run a SQL report using DTSRun. This function is no longer working and when i try to run it from the command shell i get the error;

'DTSRun' is not recognized as an internal or external command,operable program or batch file.

If anyone knows how to sort this out it would really help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Try this out for your issue....

by Peconet Tietokoneet In reply to MSSQL - 'DTSRun' is not r ...

You probably need to have that path set on the server machine. Or try putting full path such as xp_cmdshell 'x:\mssql\binn\dtsrun.....'

Put the command in the directory of
"\winnt\system32" and see if that works for you.

gravatar
Collapse -

Thanks

by zerosentiment In reply to Try this out for your iss ...

Your post gave me an idea and it worked.

put in an extra line on the script to CD to the \mssql\binn\ folder first and then run the DTSRun command.

Thanks a lot!

gravatar
Collapse -

No problem. :)

by Peconet Tietokoneet In reply to Thanks
Back to Software Forum

Start or search

Related Discussions

Related Forums