XML data need to load into SQL2k

• iBuildDW

  Mr or Mrs. 500

  Points: 587

  More actions

  September 22, 2006 at 7:54 pm

  #103243

  I have a new source of data I need to load into a data warehouse. It's in XML.

  I've loaded XML data before using an activeX script, but it was very time consuming to set up. I needed to create a schema and map each node to a database table and column. I'm thinking there has to be a better way. I'm interested to hear what others are doing to solve this integration issue.

• September 25, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Rick Ziminski

  Old Hand

  Points: 323

  More actions

  September 25, 2006 at 1:04 pm

  #662344

  See the following 3 articles for some ideas.

  http://www.databasejournal.com/features/mssql/article.php/2204421

  http://www.databasejournal.com/features/mssql/article.php/2235451

  http://www.databasejournal.com/article.php/1503191

  GL