VirtualBox doesn’t care what you use as long as you configure it properly. We can also use different versions of Linux within Linux or Windows within Windows. Please let me know if you may have a resolution to this problem.You could run Linux within Windows or the other way round. I would assume that the OracleClient 64-bit would include that. Someone mentioned on another forum that maybe there is no Oracle ODBC driver for 64-bit Windows. For both 64 and 32 bit, I use a dtsconfig file which specifies the Oracle connection string and password. When I am editting the package in BIDS I can connect to Oracle. When I run the package using the Execute Package Utility, it runs successfully. When I execute this same exact package as a SQLAgent job 32-bit (type Operating System CmdExec) it runs successfully. Source: DFT-Oracle to SS2005 DTS.Pipelineĭescription: component 'OLE DB Source' (1) failed validation and returned error code 0xC020801C.ĭescription: One or more component failed validation.ĭescription: There were errors during task validation.ĭTExec: The package execution returned DTSER_FAILURE (1). There may be error messages posted before this with more information on why the AcquireConnection method call failed. The AcquireConnection method call to the connection manager 'Oracle/PeopleSoft' failed with error code 0xC0202009. Source: DFT-Oracle to SS2005 OLE DB Source ĭescription: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

Source: 'Microsoft OLE DB Service Components' Hresult: 0x80040154 Description: 'Class not registered'. Error code: 0x80040154.Īn OLE DB record is available. Source: SADM_CURR_Address_and_Cell_Phone-Oracle Connection manager 'Oracle/PeopleSoft'ĭescription: SSIS Error Code DTS_E_OLEDBERROR. I get the following error when run as a SQLAgent job 64 Bit (Execution type SQL Server Integration Services Package). The server has been rebooted since installing OracleClient.

Oracle Client 11g (32 bit & 64 bit) Runtime Version installed on server. This is on a Windows 2008 Server (64-bit). I have an SSIS (SQL Server Integration Services) Package that reads a view on Oracle and loads data into table in SQL Server 2005.

1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.

Oracle virtualbox 64 bit error