Issue with xs: and xmlns etc SSIS not reading xml file



I am able to generate xml file using below code...I'm not able to use text.xml file by using SSIS. I'm not getting any error also. Suggest me what to do? When using SSIS with test.xml file data not inserting in table.



XmlDocument xd = new XmlDocument();
HttpWebRequest request;
HttpWebResponse response;

XmlTextReader xmlreader;

string url = "http://example.org/test";
request = (HttpWebRequest)WebRequest.Create(url);
byte[] bytes;
bytes = System.Text.Encoding.ASCII.GetBytes(xd.InnerXml);
request.Method="GET";
request.ContentType="application/xml; encoding='utf-8'";
stream sr;
response = (HttpWebResponse)request.GetResponse();
if (response.StatusCode==HttpStatusCode.OK)
{
sr = response.GetResponseStream();
xmlreader = new XmlTextReader(sr);
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(xmlreader);

using (streamwriter fs = new streamwriter(@"c:\test.xml");
{
fs.write(xmldoc.InnerXml);
}
console.writeline(xmldoc);
xmlreader.close();
response.close();


-- output of test.xml file.



<?xml version="1.0">
-<DataTable xmlns="http://ift.tt/1upOGsJ">
-<xs:element msdata:UseCurrentLocale="true" msdata:MainDataTable="Table" msdata:IsDataSet="true" name="NewDataSet">
-<xs:complexType>
-<xs:choice maxOccurs="unbounded" minOccurs="0">
-<xs:element name="Table">
-<xs:complexType>
-<xs:sequence>
-<xs:element name = "ID" minOccurs="0" type="xs:int"/>
-<xs:element name = "Name" minOccurs="0" type="xs:string"/>
-<xs:element name = "State" minOccurs="0" type="xs:string"/>
-</xs:sequence>
-</xs:complexType>
-</xs:element>
-</xs:choice>
-<xs:complexType>
-</xs:element>
-</xs:schema>
-<diffgr:diffgram xmlns:msdata="urn.schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
-<NewDataSet xmlns="">
-<Table diffgr:id="Table1" diffgr:hasChanges="modified" msdata:rowOrder="0">
<ID>2</ID>
<SN>test2</SN>
<State>KN</State>
-</Table>
-<Table diffgr:id="Table1" diffgr:hasChanges="modified" msdata:rowOrder="0">
<ID>3</ID>
<SN>test3</SN>
<State></State>
-</Table>
--
--
--
--
</diffgr:before>
</diffgr:diffgram>
</DataTable>

No comments:

Post a Comment