Scheduled DTS for Informix (ODBC Issue) failed

• yr2003ht

  SSC Enthusiast

  Points: 139

  More actions

  March 14, 2003 at 2:06 pm

  #151801

  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!

• March 17, 2003 at 8:00 am

  This was removed by the editor as SPAM

• philcart

  SSC-Forever

  Points: 47794

  More actions

  March 17, 2003 at 5:59 pm

  #451296

  First thing to do when scheduling a DTS package that you can manually execute successfully is check the permissions.

  Also, given the message says something about DLL's, maybe the DLL isn't registered properly.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface