Bulk Import... second Try...

[Kiran]

Hi,

Does some one here know how to trigger export(bulk/non bulk) and use bulk
import without having to manually edit the Xsd file before import. BTW I am
assuming that XML is the correct choice as I want to save these data in my
VSS for future after export.

=============== =============== ========
My prev Post:

I want to back up my data in some table in SQL server and import it back
using Bulk Load of SQL server 2K.

I can use the following code to backup the data in XML

dataset.WriteXm l(@"C:\Data.xml ");
dataset.WriteXm lSchema(@"C:\Sc hema1.xml");

and following code to bulk import the same data

SQLXMLBULKLOADL ib.SQLXMLBulkLo ad3 x = new
SQLXMLBULKLOADL ib.SQLXMLBulkLo ad3Class();
x.ConnectionStr ing
="PROVIDER=SQLO LEDB.1;SERVER=l ocalhost;UID=sa ;PWD=;DATABASE= demo01";
x.XMLFragment = true;
x.ErrorLogFile = @"c:\error.txt" ;
x.SchemaGen = true;
x.SGDropTables = true;
x.Execute(@"C:\ Schema.xml",@"C :\data.xml");

this do not work, but do not throw any error either, when I looked
closely... the format of the schema file is incorrect, if I create a correct
formate maually it works.

Does some one know how to generate schema file in correct format? using
..Net.

Regards
Kiran