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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Record into Oracle Table 1
Error executing DTS from vb.net app 2
IDbCommand, Oracle, Select query 1
Insert into XML column 1
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 1
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 2
SQL Job or Windows Service? 4
How do I create a standalone executable 1

Back
Top