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?