Thanks for taking time to help me understand. Few more questions:
1).Can't I directly import the data form XML file into the database like selecting the data source as XML file in the management studio (using SSIS I believe its older version was DTS packages?)? 2).What additional advantage do we have by doing it programatically using XSL and XSLT? > 2. Data form - XML 3).You mean converting from the XML to XML again using the XSL (gettting the data out of source XML file) and then XSLT (to transform to another XML format) will have more flexibility? Does it mean that source XML fromat is different from out put XML file format? If you think I am missing some thing here can you please take few minutes to understand this? Thanks in advance, L On Jan 27, 8:54 pm, Cerebrus <[email protected]> wrote: > XSL(T) is for transformation of XML data into another form: > > 1. Representational form - XHTML > 2. Data form - XML > 3. Textual form - Text. > > When you transform XML to XML, you are in fact converting the data > into a more manageable/convenient format for your purposes. > > In your case, if you need to manually import the data into the > database, you could do it directly from the XML file. If you need to > do it programmatically, you would need code because XSLT cannot insert > the data into the database. > > On Jan 27, 9:40 pm, Learner <[email protected]> wrote: > > > > > Hi, > > > I am trying to understand more about XSL and XSLT while dealing > > with XML files. If I consider a scenario of getting data in an XML > > format from another system (java) and then I want to be to able > > process those XML files and store the data (thousands of records) in > > our database (ASP.NET and SQL server) . Do I have to use XSL and XSLT > > in this process? If so can some one please help me understand where > > and why do we need these XSL and XSLT. if we do not need to use these > > two technologies just to process the XML files to store in in our > > databse then where do we use these two technologies. Appreciate your > > time. > > > Thanks in advance, > > > L- Hide quoted text - > > - Show quoted text -
