Import XML Data into SQL Server database using SSIS package?????

• Andy Tran

  SSC Enthusiast

  Points: 142

  More actions

  April 8, 2010 at 10:38 am

  #1148470

  Is possible to send me a package sample to import XML files to table?

• lesliel

  Valued Member

  Points: 72

  More actions

  June 17, 2010 at 4:55 pm

  #1181876

  It's easy without SSIS. Here's a demo

  --make the table you need

  CREATE TABLE XmlImportTesting(

  xmlFileName VARCHAR(300) NOT NULL,

  xml_data XML NOT NULL

  )

  GO

  DECLARE @xmlFileName VARCHAR(300)

  SELECT @xmlFileName = '\\aitl-testsql1\e$\EProfTestXML\Item3.txt'

  -- dynamic sql is just so we can use @xmlFileName variable in OPENROWSET

  EXEC('INSERT INTO XmlImportTesting(xmlFileName,xml_data)

  SELECT ''' + @xmlFileName + ''', xmlData

  FROM (

  SELECT *

  FROM OPENROWSET (BULK ''' + @xmlFileName + ''' , SINGLE_BLOB) AS XMLDATA

  ) AS FileImport (XMLDATA)

  ')

  GO

  SELECT * FROM XmlImportTesting

  DROP TABLE XmlImportTesting

• troy2.net

  SSC Enthusiast

  Points: 144

  More actions

  July 21, 2010 at 5:01 am

  #1196055

  @tim-2

  I have the same Problem ,

  I tried to get the datastructure same as the XML file but how

  Shall i get the data From the xml file to Table ?

  Any idea ??

• khanff

  Grasshopper

  Points: 13

  More actions

  November 21, 2011 at 11:26 am

  #1410947

  Divya,

  Can you send me the application sample?

  thanks

  fad

• rashmiptl22

  Old Hand

  Points: 351

  More actions

  November 23, 2011 at 3:19 am

  #1412026

  Hi

  Can u send a sample xml file and the details of the table u want to load the data .So that I can help you.

• nkzhangtao

  SSC Enthusiast

  Points: 157

  More actions

  March 25, 2013 at 1:34 pm

  #1600487

  ramesh.sripathi-823300 (5/5/2009)

  ---

  Hi

  I am working on SSIS

  I have an XML file that consists of nearly 5 tables of data,I have one XSD generated based on the XML file.

  I need to populate the data present in XML file into corresponding five tables

  Please help me out how to resolve this issue

  I have the same question. Did you get solution?