I am able to create and execute a DTS package that copies tables from a remote Oracle database to a local SQL server, but want to setup the connection to the Oracle database as a linked server.
The DTS package currently uses the Microsoft OLE DB Provider for Oracle with the following properties:
- Data Source:
- Password: UserPassword
- User ID: UserName
- Allow saving password: true
How do I go about setting a linked server to an Oracle database using the data source defined above?