Execute a DTEXEC batch file (.bat) in an AUTOMIC windows job

Discussion created by Richard_Wittich_482 on Feb 13, 2014
Latest reply on Feb 19, 2014 by Richard_Wittich_482





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"


echo %errorlevel%




exit /b %errorlevel%

Any help would be very much appreciated.

Rich Wittich

Lumber Liquidtaors