I have a 64-bit SQL Server 2005 database and a 32-bit Oracle 7.3.4 database on 2 different servers. I would like to create a linked server so that I can access the Oracle data from the SQL box. I have installed the 32-bit Oracle client on the 64-bit SQL box, and can connect to the Oracle server using Oracle's software. But SQL Server does not see the Oracle driver to create the linked server. The Oracle box is being phased out, but I need to copy some Oracle data to the SQL box. Any assistance would be appreciated.
Have you tried the Data Import/Export Wizard - Right click a database in the object explorer, select Tasks and then Import Data. This will let you set the connections to the Oracle source and the SQL destination and then give you the chance to select the data you want to transfer. Finally the wizard will let you execute or save the package to run at a time of your choosing.