Sympton:
You have upgraded to 14.5.x or later and when deploying SSIS packages you receive a 0xC020801C error.
Cause:
In 14.5.x we made a change (fixed a bug). We noticed that the Connection and Command Timeout was not applied to the SSIS packages as one should expect.
Resolution:
Please check the timeout settings on Data Source(s), Staging Database and Data Warehouse(s) and make sure that they have some decent settings. Setting the connection timeout to 100000 seconds will give this error on every deployment. Setting the connection timeout too low may result periodically Login Timeouts.
0 Comments