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.
| Author |
Topic |
|
vinnakanna58
Starting Member
5 Posts |
 Posted - 2009-06-12 : 06:46:00
|
| HI,I have a problem while transferring XML file data into SQL DATABASE 2005 using SSIS package.1. My XML file having multiple tags (<parent tag1>…..<child1>…..</child1></<parent tag1> …etc)2. My database having table name called(claim)with columns(i.e tags name and columns name are same)So,My problem is,I. I created one package.II. Taken one XML SOURCEIII. And I gave my source xml file pathIV. Then obviously we will get multiple outputs (i.e parent and child tags) from XML SOURCE.V. i connected that multiple outputs to union_all( y i used bcoz i need send all tags(data) to single table)VI. but after union_all i connected to OLEDB but it showing red cross mark means am not getting all tagsSo the problem is here onlyI need to send that respective tag value to database table(claim) columns.But I am getting multiple outputs from source so I need to send all data in the xml to a SINGLE TABLE…Is there is any way to send all multiple outputs to a single table in particular database.vinay kumar k |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-14 : 04:20:30
|
| see thishttp://blogs.msdn.com/mattm/archive/2007/12/11/using-xml-source.aspx |
 |
|
|
vinnakanna58
Starting Member
5 Posts |
Posted - 2009-06-14 : 23:53:54
|
| thanx for reply.........but i executed that one also....... my problem is just related to dis link........ in the link there are 2 parent nodes( counter and host) but in my xml file there are 10 like that nodes are ther..........so obviously i will get 10 outputs from source... in de above case we wil get 2 but by using merge join we can join but here there are 10 multiple outputs.........so plz solve my problem.....if u wil give u r email id i wil send my XML file and my PACKAGEvinay kumar k |
|
|
|
arcarv
Starting Member
1 Post |
Posted - 2009-06-30 : 14:18:46
|
| Hi,I am having the same issue . I have a xml with 10 or more outputs. How do I move these outputs to SQL tables along with the relations.Thanks in AdvanceArcarv |
|
|
|
|
|
|
send xml(multiple tags) data to sql using ssis