Chapter 19 included solutions for two egregious bugs:
- 1.
If the SSIS package executes for longer than 30 seconds, the PackageInfo Execute() returns an error message that reads: “The Execute method on the task returned error code 0x80131904 (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.). The Execute method must succeed, and indicate the result using an ‘out’ parameter.”
- 2.
The Execute Catalog Package Task reports success, even when the SSIS package execution fails. ...
