Click here to Skip to main content
15,884,966 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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 ,

XML
<?xml version="1.0"?>
<catalog>
   <book id="bk101">
      <author>Gambardella, Matthew
      <title>XML1
      <genre>Computer
      <price>44.95
      <publish_date>2000-10-01
      <description>




XML
<?xml version="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 :)
Posted
Updated 25-Apr-18 6:58am
v2
Comments
Santosh kumar Pithani 26-Apr-18 0:29am    
i think your have to add addition root tag ex:"<root>all rows xml data "
Amirsalgar1 26-Apr-18 6:35am    
@Santosh :Thank you for your reply , The requirement is i should not change the xml file :(
Santosh kumar Pithani 26-Apr-18 6:48am    
update your question with xml data as well as what you have tried i mean code of one row you fetched.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900