How to map the structure of one dataset to other?

  • Thread starter Thread starter Guest
  • Start date Start date
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...
 
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
 
Back
Top