Hello Guys ,
I am new to SSIS , i got a task where i have to load the XML file to the SQL server
the XML file has more than 200 XML records in it as below example ,
="1.0"
<catalog>
<book id="bk101">
<author>Gambardella, Matthew
<title>XML1
<genre>Computer
<price>44.95
<publish_date>2000-10-01
<description>
="1.0"
<catalog>
<book id="bk102">
<author>Gambardella, Matthew
<title>XML fffff Guide
<genre>Computer
<price>44.95
<publish_date>2000-10-01
<description>
i am using xml source to load the data , but i am getting only 1 record from the xml file , can anyone help to know i can get all the records from this xml file , the requirement is i should not change anything in xml file
Thanks in advance :)
What I have tried:
i am using xml source to load the data , but i am getting only 1 record from the xml file , can anyone help to know i can get all the records from this xml file , the requirement is i should not change anything in xml file
Thanks in advance :)