Post reply

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

  • April 8, 2010 at 10:38 am

    #1148470

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

  • 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

  • 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 ??

  • November 21, 2011 at 11:26 am

    #1410947

    Divya,

    Can you send me the application sample?

    thanks

    fad

  • 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.

  • 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?

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply