April 4, 2012 at 5:27 am
I need to Load multiple outputs from XML Source to Single target, How should I do that?
I dont have common column connecting XML output1 and XML output2 to merge these outputs..
Is there any other way?
April 5, 2012 at 3:53 am
Can you give more info on those outputs and on how the destination table looks like?
Sample data would be appreciated.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 5, 2012 at 4:03 am
My data in Single record would look like
<Claim>
<ClaimControls>
<Batch_ID />
<Process_Date />
</ClaimControls>
<ClaimHeader>
<Claim_ID />
<Name />
</ClaimHeader>
<ClaimInfo>
...
</ClaimInfo>
<ClaimDetail>
<Detail ID />
<Date />
<Amount/>
</ClaimDetail>
<ClaimDetail>
<Detail ID />
<Date/>
<Amount/>
</ClaimDetail>
</Claim>
Target : Flat File
Flat file Def: Claim_ID |Name|Detail ID|Date |Amount
April 5, 2012 at 4:46 am
And what are those multiple outputs?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 5, 2012 at 5:21 am
These are the four outputs produced
<ClaimControls />
<ClaimHeader />
<ClaimInfo />
<ClaimDetail />
I need to merge ClaimHeader and ClaimDetail to load into single flat file.
April 5, 2012 at 5:46 am
The only thing I find is this blog post:
However, the XML in the example seems to have a better nested structure than yours.
The article says:
These outputs are linked with IDs, which you will have to join yourself with a merge join transform.
Don't you have those IDs?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply