On Fri, Jan 28, 2011 at 10:37 AM, Learner <[email protected]> wrote: > 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? ------------------------------------
You could pass the data from the XML document to a dataset. That is either easy or difficult all pending on the schema. >From a dataset you could do anything back to a db right? -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell
