which is better call stored procedure or xpath xml

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

which is better call stored procedure or xpath xml

Author

Topic

Nader
Starting Member

41 Posts

Posted - 2010-04-30 : 11:07:49

which is better performance?
I have a list of small xml files that we receive at different instances. We need to extract a portion of the data from each of those files and populate several tables. A sample is below. Is it better to go thru the files using loopcontainer read file by file call a stored procedure that performs the extraction of the data and populate the tables or xpath and split in an ssis package if xpath and split give me a hint how to do that.
how to use openxml to extract the xxxx from the following xml file
note the 0000 are values not required
to populate two tables first table with the following columns( id,fn,family,email) the other table (id,customerrole)

<root>
<properties>
<datasource>00000000</datasource>
<datetime>000000</datetime>
</properties>
<person>
<sourcedid>
<source>00000</source>
<id>yyyyyyyy</id>
</sourcedid>
<userid useridtype="Logon ID" password="000000">0000000</userid>
<userid useridtype="SCTID" password="yyyyyyyyy">yyyyyyyy</userid>
<userid useridtype="Email ID">00000</userid>
<name>
<fn>yyyyyyyy</fn>
<n>
<family>yyyyyy</family>
<given>0000000</given>
</n>
</name>
<demographics>
<gender>00000</gender>
</demographics>
<email>yyyyyyyy</email>
<adr>
<street>000000</street>
<locality>00000</locality>
<region>00000</region>
<pcode>00000</pcode>
</adr>
<institutionrole primaryrole="00000" institutionroletype="000000"/>
<institutionrole primaryrole="00000" institutionroletype="yyyyyy"/>
<extension>
<myperson>
<academicmajor>000000</academicmajor>
<academicmajor>000000</academicmajor>
<customrole>yyyyyyy</customrole>
<customrole>yyyyyy</customrole>
<customrole>yyyyyyy</customrole>
<customrole>yyyyyyyy</customrole>
<customrole>yyyyyyy</customrole>
</myperson>
</extension>
</person>
</root>

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-01 : 01:06:08

this is third thread you've opened for same question

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=143820

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Nader
Starting Member

41 Posts

Posted - 2010-05-04 : 21:15:04

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources