Inserting records into SQL Server from Oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Has anyone ever grabbed records from oracle and inserted them into SQL
Server. I have been tasked with converting some DTS packages into VB.net
applications. What I want to do is not have the VB app interact with DTS at
all. Any help would be greatly appreciated.
 
have two data adapters, one for Sql Server and one for oracle. The Sql
Server one only needs a valid select command - the oracle one needs only
insert command.

Set the acceptChangesDuringFill property of the SqlServer adapter to false.
Fill the datatable with it.

Then, call update with the Oracle Adapter passing in the same table as the
argument. IF the column names are different, specify them in the colum
mappings collection.

This isn't efficient per se, but it will get you there
 
Back
Top