I need to update a table that resides on another server (Oracle) based on data from a table that is on a SQL server. I'm trying to do this via a DTS package and an ActiveX vbscript, however, I can't seem to get the proper syntax for updating every row of the table which has many fields. Are there any examples out there for this sort of thing? I have the DTS package variables established for DB connection info, I just need some help pertaining to the UPDATE process(possibly using a CURSOR for each row???) Any help or advice would be greatly appreciated!
Thanks,
Doug