We execute a number of SSIS packages to fetch data from various sources into Teradata. Very often (once a week) one of the packages would fail when loading data into Teradata with the following error message
The AcquireConnection method call to the connection manager <<connection>> failed
with error code 0x80004005. There may be error messages posted before this with
more information on why the AcquireConnection method call failed. <<Teradata destination table>> failed validation and returned error code
0x80004005.

If we re-run the SSIS package that failed, it works fine. Just wondering if anyone has come across this issue and if you have any solution for this. We are using Microsoft Connector for Teradata by Attunity 3.0 and the SQL Server version is 2014 (64 bit) Enterprise.