Using XML Source to read XML file (funnily enough)

Question

Using XML Source to read XML file (funnily enough)

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

supjo Mr or Mrs. 500 Points: 583 More actions · Answer 1

I faced with a similar issue few weeks back. You need to use SORT for the child output and sort it by the Parent_Id. Then use MERGE JOIN to merge the output from the Parent output and the sort output.

Sequelsurfer SSCrazy Points: 2562 More actions · Answer 2

Thanks but I was trying to avoid SORT tasks for obvious reasons.

I have actually managed to get it bottomed out. In the end I used an XSLT transformation to 'flatten' the XML which took away most of the problems. This then only left the issue of using variables in the XSLT Task, now that WAS a whole new ballgame. So glad of all the updates on this (and other) forums and the multitude of blogs that eventually got me to where I needed to be.

Thanks for taking the time to reply anyway.:-)