XML Task doesn't like attributes, it prefers only fully formed tags. When you want access to the attributes, you've got to fuss with it a bit.
A brief example:
http://www.mandsconsulting.com/ssis-tip-xpath-for-root-level-attributes-xml-tasks
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA