I set up a DTS package using an Oracle connection and a SQL Server connection. For the Oracle connection, I used the Microsoft OLE DB Provider for Oracle. For the SQL Server connection I used Microsoft OLE DB Provider for SQL Server. When I set up the transform to go from SQL Server to Oracle and right click it to go to properties, it hangs for a minute or so but then goes in and I am connecting both to Oracle and SQL Server. When I set up the transform to go from Oracle to SQL Server, it hangs indefinitely and then times out. I tried using the Microsoft ODBC Driver for Oracle and got the same results. Any ideas?
