September 8, 2016 at 11:57 am
Hi,
I have a XML file which has many nodes and many columns. I want to get most of the columns from all nodes into one single table in sql server.
i have used XML source task but this task splits the data into multiple tasks. I cannot use merge because columns cannot be joined.
how can I do this in SSIS? I just want all the XMl columns and data in one single table. Is there anyway we can do this?
Any help is appreciated!!
September 9, 2016 at 7:55 am
OPENXML should work just fine for this task.
-- Itzik Ben-Gan 2001
September 9, 2016 at 9:35 am
Hi,
OPENXML works fine if all have single parent node.
But I might want columns for different nodes. Do we have any option?
Thanks
September 9, 2016 at 10:11 am
hegdesuchi (9/9/2016)
Hi,OPENXML works fine if all have single parent node.
But I might want columns for different nodes. Do we have any option?
Thanks
Post a sample of the XML you're working with and desired results. I'm pretty sure I can show you a few ways to tackle this.
-- Itzik Ben-Gan 2001
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy