Each one of the bat files calls for a different SSIS package. I want the program to run them all even if they fail. This is the content of my bat file:
call "IncrementalARSON.bat"
call "IncrementalHAZARDOUS.bat"
call "IncrementalFIREMODULE.bat"
call "IncrementalINCIDENTTABLES.bat"
call "IncrementalRESTTABLES.bat"
Each bat calls a different SSIS package, for example the ARSON one:
“C:Program FilesMicrosoft SQL Server160DTSBinnDTExec.exe” /FILE “D:IntegrationServicesNFIRS-IncrementalDataLoadIncrementalLoadNFIRSFiles_Arson.dtsx” >ArsonLogs.txt
Problem: it runs only the first one regardless if it fails or not (which is what I want) but wont run the rest of bat files.
I tried running the one bat file expecting to run all bat files inside but that did not happen, ran only first.
Flor Whitehead is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.