Xml File Import - Relational Data

Hot Topic

MSMQ Connection Manager and input into a data flow
From MySQL to MSSQL 2005
Report Models using Islookup and expandinline
SQL Express with Advanced Services - what Reporting Features does it have?
Pre-installation problems
i need to migrate from sql 2005 express to sql workgroup edition
To add one report or many
Problem installing sql 2005 express ---cannot start service etc.... :(
BI/SSIS Developer environment?
VS.NET 2005 and CLR stored procedure permission sets.

SQL Server

Error data types do not match
Reporting Services 2000 and Visual Studio 2005
dynamic query
Insert Parent Child records...
recursive queries
Network access to Sql Server 2005 Express
Getting error in Execute SQL Task
Help with query
how to let others connect to my sql server 2005?
for loop container to process all Excel files

Xml File Import - Relational Data

Hi,

I have played around with SSIS in addition to reading an SSIS book front to back, but I am still a little confused as to how to import an Xml file with relational data.

The Xml file is structured as follows:


Answer this question

Xml File Import - Relational Data

  • kthiagar

    have you tried using the t-sql openxml statement with the execute sql task


  • prof.Scuba

    Duane Douglas wrote:
    have you tried using the t-sql openxml statement with the execute sql task


    Thanks for the suggestion, it had crossed my mind but then it seemed to contradict the main point of SSIS, that being making it easy to import data with little coding.

    I have since discovered that the Xml Source task builds up the relationships internally and adds automatically generated PKs/FKs, so I should be able to use those to map the data.
  • Xml File Import - Relational Data
Answer this question