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.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  ssis xml task xpath output format

Author  Topic  Nader Starting Member 41 Posts Posted - 2010-05-11 : 01:15:12 I used ssis xml task xpath the out put was in the form of <ResultRootNode> <fn> xxxx</fn><family>cccc</family><email>xxxxx<email><customrole>ggggg</customrole> <customrole>kkkk</customrole> <customrole>ffffff</customrole> <fn> hhhh</fn><family>jjjj</family><email>kkkk<email><customrole>ggggg</customrole> <customrole>sssss</customrole><customrole>wwww</customrole> </ResultRootNode> _________________ I want my output to be in the form of <ResultRootNode> <person> <fn> xxxx</fn><family>cccc</family><email>xxxxx<email><customrole>ggggg</customrole> <customrole>kkkk</customrole> <customrole>ffffff</customrole> </person> <person> <fn> hhhh</fn><family>jjjj</family><email>kkkk<email><customrole>ggggg</customrole> <customrole>sssss</customrole><customrole>wwww</customrole> </person> </ResultRootNode> ____________________ see attached document for more explanation Thanks for your help in advance