August 27, 2009 at 4:04 am
Hi
I'm building an SSIS package; bringing data in from xml using XML Source, doing some Data Conversion and outputing to OLE DB Destination. So far so good - I have successfully loaded test data.
The only proble is my XML relational structure is up to 4 levels deep in terms of child-parent relationships. I.e. a House, has many Rooms, those Rooms and many 'Attributes' and each 'Attribute' has potentially many Items of work required against the attribute e.g. Item 1. replace glass window and Item 2. paint window seal etc.
How do I preserve this xml relational structure in the DB? I.e. so all child data at all levels is preserved (and uniquely held against the house, and not another house, or a less desirable option)?
Any help you can give is muchly appreciated!
Thanks
Mat:-)
August 27, 2009 at 9:16 am
I can't help you with the XML part, but the first thing you need is properly designed table(s) so that you can properly store the information.
Do you have that?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 27, 2009 at 3:45 pm
You'll notice if you look at the metadata for each of the outputs from the XML source, that the parent node ID is included as metadata for the dependant nodes. You can use this to link nodes to their parents.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply