I am setting up a DTS package to extract data from Oracle 7 to SQL Server 2000.
When I click the Microsoft ODBC Driver for Oracle icon, I got the following error:
'Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [Microsoft][ODBC driver for Oracle][Oracle]
I have Oracle Client 9i and MS ODBC Driver for Oracle installed in the client machine.
Any help would be appreciated.