Job fails with an error 'A dynamic link library (DLL) initialization routine failed.'
We have an MS SQL SSIS package deployed onto production environment--- a 64 bit server A, which will grab some Tedadata data from Server B, and server A got Teradata OLE DB provider version 12.0 installed, we created a job on Server A and run it, we got the following error:
Error: 2009-02-04 13:42:35.99
Source: ARSR Connection manager "GDW"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007045A.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007045A Description: "A dynamic link library (DLL) initialization routine failed.".
ARSR is the SSIS package name, 'GDW' is the connection manager connecting to Teradata.
Actually we tested SSIS package(created a job and run it, which runs the SSIS package) in our assurance testing environment(a 64 bit server A1 and a server B1), it works fine.
We compared these 2 environment, both got same version of Teradata OLE DB provider driver installed, we can't figure it out why we get the above error.