I am trying to execute a DTEXEC batch file (.bat) in an AUTOMIC windows job, but the job seems to be looking on the AUTOMIC server not the target server for the executable. The job fails every time saying it can’t find DTEXEC. We moved a copy of DTEXEC to the AUTOMIC server, and the job stopped failing, but of course nothing happened because SQL server is not running on that box.
Here are the contents of my batch file:
echo Loading BPC Data
dtexec /f "E:\PC_MS\Data\Webfolders\Madeira\Landing\DataManager\PackageFiles\CustomFiles\Load_BPC_Data_All.dtsx"
exit /b %errorlevel%
Any help would be very much appreciated.