sindangwangi
New Member
I'm having some issues with an XML Data source. Basically I want to hit the xml document, then pull back the two values (status and description) in the document and log them to a table. When I try to look at the available columns in the document I don't see any available in the XML Source Editor SSIS screen, I receive no errors when clicking on the columns tab, just no columns appear to be available. I'm guessing that the xml data isn't complex enough in order to consume it from reading the following sites:http://resquel.com/ssb/CommentView,guid,4fac4c46-b1e1-48a5-9434-4fa5e3eac48f.aspxhttp://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspxHowever I can't find any documentation that tells me definitively one way or the other. Any help is greatly appreciated!XML doc here:\[code\]<?xml version='1.0' encoding='ISO-8859-1'?><Response> <Status>Error</Status> <Description>Transaction Already Approved</Description></Response>\[/code\]XSD format I'm using here:\[code\]<?xml version="1.0"?><xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="Response"> <xs:complexType> <xs:sequence> <xs:element minOccurs="0" name="Status" type="xs:string" /> <xs:element minOccurs="0" name="Description" type="xs:string" /> </xs:sequence> </xs:complexType> </xs:element></xs:schema>\[/code\]