I am getting an error message “A dynamic link library (DLL) initialization routine failed.” when I try to access Teradata database from within my ETL tool, SQL Server Integration Services (SSIS) 2008 package.
A bit more detail on the error description:
A dynamic link library (DLL) initialization routine failed.". ..Error: 2014-05-19 06:00:02.77 Code: 0xC020801C Source: OLE DB Source  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Source_Teradata" failed with error code 0xC0202009
This error started occurring ever since I uninstalled the v12.0 of Teradata drivers and installed v14.0 of Teradata Drivers & Utilities. Prior to this uninstallation, the SSIS packages were working fine connecting to Teradata database.
Some of the environment details are as below:
OS: Windows Server 2008 R2 Enterprise
Teradata Drivers: v14.10 32-bit
Teradata Utilities: v14.10 32-bit(FastExport/FastLoad/BTEQ/Multiload)
Note: Exactly the same installation in Staging environment, however, is working fine.
Any thoughts on this issue please.
This issue has now been resolved by restarting the SSIS service and SQL Agent server.
However, it is strange that we didn't have to restart the services in Staging environment but had to do it in Production env.
Thanks anyway for showing interest in this issue.