How to map the structure of one dataset to other?

G

Guest

I am working on a project in VB.Net which mostly deals with ADO.Net..
The tool I am working is an Import & Export Tool..It transfers data from any platform to any other i.e from Oracle to SQL Server or viceversa and Oracle to Access or viceversa and also textfiles..
So, I generate a dataset with source data that the user want to transfer ..Also ,I generate another dataset with target table which is empty...So, I have to map these two datasets depending on the field names and their datatypes so that correct is loaded to correct place..
It might be possible using xml or without xml..
Please help to do in either way...
 
M

Mary Chipman

You might want to investigate DTS (Data Transformation Services) in
SQL Server 2000. It will likely be more efficient than attempting to
transform data using client code. See SQL Books Online for more
information. Also, there are many good third-party books and resources
for DTS, such as http://www.sqldts.com.

--Mary
 

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

How to translate heterogenious XML files to typed datasets? 2
Generate DataSet in 2.0? 9
DataSet to Dataview to Dataset to XML! 2
SQL Table to DataSet to Dataview, to DataSet to XML! 4
How to get the last created or modified dataset 1
how to convertan ado recordset xml format to an ado.net dataset xml 1
Map datatable A to datatable B 3
how to load timestamp type in dataset in oracle and sqlserver 2

Top