SQL DTS PACKAGE to ORACLE SERVER -
02-21-2006
, 10:42 AM
Hello:
I am trying to write a package that writes data from a 2,000 SQL SERVER to
an ORACLE SERVER 10 (USING Microsost OLEDB Provider for SQLSERVER to
Microsoft ODBC DRIVER for ORACLE ), but everytime when I try to set the
ORACLE DESTINATION SERVER I am getting a time out. The same user lets
me write information from oracle to SQL SERVER, but not the other way
around, I specify the select and it works, so i can read the information
fromthe oracle table not not to write to it
Any help will be appreciated |