1) Yes, that's what I meant by saying "manually import" the data.
2) As I said, it can make the data import easier if you have a simpler XML file. Some XML sources can get severely convoluted because XML is dependent on the whims of the creator. It can be very complex to parse particular data out of such an XML file. Prior transformation to a format that contains only the data you need can be a helpful step. 3) Already explained in 2). Feel free to ask if you have other questions. On Jan 28, 9:37 pm, 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? > > Thanks in advance, > L >
