Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLXMLBULKLOAD mapping file Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 11:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 10:59 AM
Points: 6, Visits: 17
Hi,

I tried SQLXMLBulkLoad option by creating the mapping file and VB script, its not giving any error when I run the VB script and not loading the data into temp table.Here is my mapping file and VB script. How to map the attribute value job id into sql field along with cycle_no and pdm elements
and How to map the hard coded table name to sql:relation valueÉ


Customers.xml :

<?xml version="1.0" ?>
<batch>
<job id="100360003">
<cycle_no type="string">36</cycle_no>
<PDM type="string">C</PDM>
</job>
<job id="100360004">
<cycle_no type="string">36</cycle_no>
<PDM type="string">C</PDM>
</job>
</batch>

Customermapping.xml :

<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql" >


<AttributeType name="Id" />
<ElementType name="Cycle_no" dt:type="string" />
<ElementType name="PDM" dt:type="string" />

<ElementType name="batch" sql:is-constant="1">
</ElementType>

<ElementType name="job" sql:relation="temp_xml">
<attribute type="Id" sql:field="Id" />
<element type="Cycle_no" sql:field="Cycle_no" />
<element type="PDM" sql:field="PDM" />
</ElementType>

</Schema>

Insertcustomers.vbs

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=XXXXXXXX;data source=XXXXXXXX;database=XXXXXX;uid=XXXXXX;pwd=XXXXX"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "c:\customermapping.xml", "c:\customers.xml"
Set objBL = Nothing


Post #1467297
Posted Tuesday, June 25, 2013 11:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
Points: 12,921, Visits: 32,285
duplicate post.
There's no need to post the same question in multiple forums.
The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.
crossposting will wastes people's time and fragments replies.

No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic1467296-21-1.aspx


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1467299
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse