XML Import

  • Looking for a basic article that imports a series of XML files in a folder into a table. There should be some element in the XML documents that maps to a PK or other value in the table.

    Separate articles for SSIS, PoSh, or other techniques.

  • I should be able to write on an SSIS-driven ETL process using XML files as a source and also touch on XML validation.

    [font="Arial"]Matthew[/font]

  • That would be good, but a basic, simple, 2 pager on importing separately would be good.

  • Not a problem. I can instead focus on reading and inserting XML files using T-SQL and follow up at a later time with an article on a simple iterative data flow for a collection of XML files.

    [font="Arial"]Matthew[/font]

  • Article submitted. I would like to submit a follow up article next month on building a simple SSIS ETL process for importing multiple XML source files.

    [font="Arial"]Matthew[/font]

  • Excellent, and thanks.

    Always feel free to submit anything else. These are just specific ones I noticed we needed.

Viewing 6 posts - 1 through 5 (of 5 total)

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