Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problems : DTS with ORACLE as destination Expand / Collapse
Posted Friday, December 12, 2008 10:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 30, 2016 10:39 PM
Points: 61, Visits: 786

Currently in a spot of bother and would greatly appreciate any advice with respect to the folowing..

We do need to transfer some data from SQL Server (2000) Source to the ORACLE (9i) detination table. The source has a datetime stamp which to be used to transfer the most recent data since the last transfer. In destination, only the unique rows need to be appended while the existing rows need to replaced.

The initial solution did contain a couple of temporary tables in both the environment, but unfortunately, the client is not very comfortable with the new tables...

Need to know...

A. If it is possible to update a global variable from TSQL (For example, whether it is possible to update a global variable with 'SELECT MAX(Dt) FROM ORACLE.TABLE')

B. If the entire activity can be accomplished by activex scripting. ie using vbscripts, creating sql and oracle connection and recordset objects, looping through the recordset, and calling an ORACLE SP (as done so widely in vb) with the field values as SP parameters.

Thanks in advance.


Post #618795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse