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 SOURCE
III. And I gave my source xml file path
IV. 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 tags

So the problem is here only
I 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.