CODEWITHSUNDEEP
ssisbatch-filebatch-processingerrorlevel
tsilb
tsilb

Reputation: 8037

How to set ERRORLEVEL in SSIS?

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?

Upvotes: 0

Views: 1899

Answers (1)

Ed Harper
Ed Harper

Reputation: 21505

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.

Upvotes: 1

Related Questions