You'll need to use a Script Task component to accomplish your task. A great example and explanation can be found at:

Good luck.

To make your XML more readable, use xlst to transform it. For more info try: http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog