Share via

XML files loading through SSIS

cmk 21 Reputation points
2020-11-22T00:23:58.88+00:00

Hi All,

I have single xml file have multiple nodes. How can I load all the nodes information into single table.

Thanks,

CMK

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,856 Reputation points
    2020-11-22T01:39:22.887+00:00

    Hi @cmk ,

    SSIS has XML Source Adapter to do that.
    Check it out here: importing-xml-documents-using-sql-server-integration-services

    0 comments
  2. Monalv-MSFT 5,901 Reputation points
    2020-11-23T01:44:31.907+00:00

    Hi @cmk ,

    The XML source generates tabular structures from the XML data by creating an output for every element that contains other elements in the XML files. For example, if the XML data represents catalogs and items in catalogs, the XML source creates an output for catalogs and an output for each type of item that the catalogs contain. The output of each item will contain output columns for the attributes of that item.

    We can use XML Source in the Data Flow Task.

    Please refer to Import XML documents into SQL Server tables using SSIS packages.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.