I've been tasked with building a replacement SQL Server that extracts data from Oracle and publishes it to a Third Party. The new Server is of a higher spec than the existing SQL Server and the Server in question is not performing any other role.
The Network config between the two SQL Servers is identical; Firewalls are also configured correctly. Both Servers are using the same Switch.
However when I attempt to replicate the DTS Packages and SSIS, i'm getting a Timeout problem when Management Studio is attempting to populate the list of Objects from Oracle. Is there anything from a SQL Perspective that could be causing the issues?
New Server is SQL Server 2005 Standard Edition SP3. Old Server is SQL Server 2000 Standard Edition SP4.Tony C
View Complete Post