Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS Package Error Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 4:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 12, 2011 3:26 AM
Points: 1, Visits: 6
Hi,

I'm having problems with a DTS package that copies data from an Oracle database to a SQL database. The package runs successfully if it is manually executed however fails every time it is scheduled. The error given in the Job History is as follows:

Error = -2147467259 (80004005) 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 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0)

When I try to recreate the package on a test server or try to edit the package on the live server, I get two errors which are:

The Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.
You will be unable to use this driver until these components have been installed.

and

HResult of 0x80004005 9-2147467259) returned
Unexpected error occurred. An error result was returned without an error message.

This was using Microsoft ODBC Driver for Oracle and I've tried recreating the package with the OLE DB Provider for Oracle and get the Hresult error but no Oracle driver error. I've also tried updating the Oracle driver on the server to no avail!

Does anyone have any ideas what the problem could be?

Thanks,

James
Post #683958
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse