Retrieve Part of XML File

Today I faced a question on changing style of an xml file and fetch desired result as another xml file,  The XML file has lots of un-necessary tags which should be removed , I tried to do this with C#.NET code. This is the input xml: <?xml version="1.0" encoding="utf-16"?><DataTable>  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">    <xs:element Read more about Retrieve Part of XML File[…]

SSIS – Sql Server to XML – Save to file

As you know there is no XML destination in SSIS. so how you can save result of a query from sql server to XML file? Solution is: First Of all you can use FOR XML to get result of query in XML , look at our sample query : SELECT EmployeeID,NationalIDNumber,ContactIDFROM HumanResources.Employee FOR XML RAW(‘Facility’),Root(‘Extract’),Elements  Read more about SSIS – Sql Server to XML – Save to file[…]

XML Task – Changing Style of Data – XSLT

I wrote about Validation with XML Task in SSIS here before, now I want to write about XSLT in this post. XSLT is an acronym of eXtensible Stylesheet Language Transformation. XSLT can transform given XML document to new style. this is very good way for reading complex XML documents where XML source has week ability Read more about XML Task – Changing Style of Data – XSLT[…]