Post reply

DTS package won't run as job

  • June 25, 2003 at 10:13 am

    #106096

    I have a DTS package that copies some data from MS SQL server to an Oracle server. The packages runs without error if run in DTS Designer but fails on the first step which uses the Oracle ODBC connection. Preceding SQL steps run against the local SQL Server run OK. The error I get is:

    Error: -2147467259 (80004005); Provider Error: 0 (0)

    Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

    Error source: Microsoft OLE DB Provider for ODBC Drivers

    Help file:

    Help context: 0

    I have found nothing in the Microsoft Knowledge base about this. Has anyone else seen this and found a fix?

    Mark Hottinger

    Mark

  • June 25, 2003 at 12:17 pm

    #463110

    quote:

    The packages runs without error if run in DTS Designer but fails on the first step which uses the Oracle ODBC connection.

    Did you run the package successfully from client machine with EM installed or from SQL Server machine?

  • June 25, 2003 at 1:08 pm

    #463117

    I ran the package at the server console, not from a client.

    Mark

    Mark Hottinger

    Mark

  • June 25, 2003 at 1:28 pm

    #463119

    Which account did you use to run DTS package from server console? Is it same as the SQL Server Agent account? Who is the job owner?

  • June 25, 2003 at 4:32 pm

    #463142

    I used my own account which was a sysadmin account using SQL Server authentication.

    I have a tip that problem might be resolved by stopping and restarting SQL Server. SQL Agent may not have access to all it needs to run job because it was started before Oracle Client install.

    I'll let you know if this works.

    Mark Hottinger

    Mark

  • March 19, 2008 at 9:08 am

    #791496

    Hey Mark,

    I am having the same problem. Can you please tell me if you found any solution to this?

    Thanks,

    Sourabh

    Thanks,
    Sourabh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply