Richard_Wittich_482

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

 

Hello,

 

 

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%

 

pause

 

exit /b %errorlevel%

Any help would be very much appreciated.

Rich Wittich

Lumber Liquidtaors

 

Outcomes