dbTalk Databases Forums  

SQL DTS PACKAGE to ORACLE SERVER

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL DTS PACKAGE to ORACLE SERVER in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gina Hernandez
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.