SQL Server 2k (Sp2):
I have a DTS package with an Informix ODBC connection. Package runs successsfully when I execute manually. When I try to schedule it as a job, it gives me an error trying to load the ODBC driver.
This is the error I get when it is scheduled as a job:
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: [Informix][Informix ODBC Driver]Unable to load translation DLL.
Error source: Microsoft OLE DB Provider for ODBC Drivers
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 11048 (2B28)
Error string: [Informix][Informix ODBC Driver]Unable to load translation DLL.
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
Appreciate your help!