Hi Ranjan,

Why not to upsize vfp table to MS SQL?

Aashish

>I need to import a vfp table into sql-server 2000.
>I do the following:
>- export my table with
> CursorToXML("tmptracking", "c:\temp\msdstracking.xml", 1, 2 + 32 + 512, 0, "c:\temp\msdstracking.xsd")
>- import the data as follows:
>BulkLoadObj = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
>BulkLoadObj.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=MSDS ;Data Source=NL9BD770J;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;User Id=sa;pwd=; network library=dbmssocn"
>*'Add Code to set other properties of the XML Bulk Load object as required
>BulkLoadObj.ErrorLogFile = "c:\temp\msdstracking.err"
>BulkLoadObj.IgnoreDuplicateKeys = .T.
>BulkLoadObj.Transaction = .T.
>BulkLoadObj.Execute("c:\temp\msdstracking.xsd","c:\temp\msdstracking.xml")
>BulkLoadObj = NULL
>
>The most interesting part: no error is generated but nothing is imported into sql-server. It does not even generate an error.
>What am I missing here?
>
>
>The xml file contains just one line:
>

><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><VFPData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="c:\temp\msdstracking.xsd">
>	<tmptracking>
>		<trarktx></trarktx>
>		<trernam>DC841</trernam>
>		<trkunnr>0006814856</trkunnr>
>		<trland1>NL</trland1>
>		<trmaktx>LDL Emmerich     Bg   5Kg BPM     4inBox</trmaktx>
>		<trmatnr>000000006100001679</trmatnr>
>		<trname1>NOVA CHEMICALS NETHERLANDS B.V.</trname1>
>		<trname2></trname2>
>		<tronzin></tronzin>
>		<trort01>BREDA</trort01>
>		<trprod_co>65998</trprod_co>
>		<trpstlz>4800 DJ</trpstlz>
>		<trregio></trregio>
>		<trstras>PO Box 3355</trstras>
>		<trvbeln>6123020934</trvbeln>
>		<trwadat>20000327</trwadat>
>		<trzeof></trzeof>
>		<trrev_nr>0.2</trrev_nr>
>		<trregion>ROW</trregion>
>	</tmptracking>
></VFPData>
>