I have a batch file that runs an SSIS job. I have no knowledge of how the SSIS job runs, I took over a project involving it.
The batch file uses %ERRORLEVEL% to detect errors that occur within the SSIS job. It must be expanded to report other errors too.
How do I set the ERRORLEVEL in SSIS?
This doesn't appear to be possible. Based on the MSDN documentation, dtexec can only return error codes from 0-6. If you need more detailed error trapping, you will need to store and parse the output from dtexec.