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.