hello,
i want to pass all data thru XML in sqlserver and data may be heavy. i
ev come to know about XMLSQLBulkLoad Component but i dont know how to
use it.
see, we have specified schema format and its complex. can i still use
this component for data loading?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Since SqlXmlBulkload uses a streaming model - it can be used for arbitrary
large source documents.
The mapping is actually quite flexible, but it does have limitations. In
general, this means that the layout of the XSD must roughly match in
structure the underlying tables you are loading in to. However, you would
have to post your specific XSD and DDL to truly assess whether you can use
SqlXmlBulkload without work arounds (i.e. transforming the data before
load).
Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment