Running a batch file in SQL server 7
I have written a batch file which is working perfectly all right when I run it manually.
I want to run this batch file through SQL server 7. I have created a DTS package and when I run the package manually it works but when I schedule the same package it is giving me a run time error.
Actaully, I am running an SFXCL.exe file under the batch file. When job runs it keep saying "
'SFXCL.exe' is not recognized as an internal or external command, operable program or batch file. "
Then I change the path directly to the SFXCL.exe file which is C:\Program Files\SecureFX\SFXCL.exe but it did not work.
Any kind of suggestion or help will be highly appreciated.
Thanks in advance!!!!
__________________
|