Job fails with an error 'A dynamic link library (DLL) initialization routine failed.'

Connectivity

Job fails with an error 'A dynamic link library (DLL) initialization routine failed.'

Hi,

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

Code: 0xC0202009

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.".

End Error

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.

Can somebody please help?

Thanks,

Morgan