Two egregious bugs remain in the Execute Catalog Package Task code:
- 1.
The Execute Catalog Package Task reports success, even when the SSIS package execution fails.
- 2.
If the SSIS package executes for longer than 30 seconds, the ExecuteCatalogPackageTask.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.” ...
