Hello SSIS World, From XML!

  • The source attached to this article seems to be corrupt.

    Download it from here:


  • New .ZIP uploaded with the file in it. Appears to download and open for me.

  • It's working on 2005 now thankyou!

  • Thanks for the article.

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Why was this not done entirely in the data flow, where batch inserts could be done, as opposed to row-by-row in your method? You can use a data viewer in the data flow to inspect the data as well, rather than going through all of the extra work to display a message box?

  • Why did you use an ADO .NET Source instead of a OLE DB SOurce?

  • I just meant this as an introduction, thus the "Hello World" allusion.

    The hardest part is just figuring out some way to get XML into the project.

    As you point out, once you get the XML source working, there are a million ways to go from there.

  • Stan Kulp-439977 (4/15/2010)

    I just meant this as an introduction, thus the "Hello World" allusion.

    Agreed, but using a recordset/foreach loop and a script task is not quite "hello world" material. Connecting the source you already have in your data flow to an OLE DB Destination and right-clicking on the path between them and selecting "Data Viewer" is, however. 😉

    Your solution works great if you want to do something on a row-by-row basis - like call a Web service.

  • I found the .dtxs package but I don't know what version was used here. When I open up the XML Source component, there is NO "Generate XSD" button.???? I tried in both SSIS 2005 and 2008 and neither one has a Generate XSD button. And I'm using the Developer Edition..

  • I made it in 2005. I just got 2008 Developer and it's not there. In 2005 the XSD file says it was created by Liquid XML Studio Community Version. Since Liquid discontinued the Community version, I guess they had to ditch the functionality.

    You can use the free version of XMLFox (http://www.xmlfox.com/) to generate one.

    Or you can copy-and-paste this code I just generated:

    <?xml version="1.0" encoding="utf-8" ?>

    <!--Created with Liquid XML Studio - FREE Community Edition (http://www.liquid-technologies.com)-->

    <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

    <xs:element name="ROOT">



    <xs:element minOccurs="0" maxOccurs="unbounded" name="row">


    <xs:attribute name="firstName" type="xs:string" use="optional" />

    <xs:attribute name="lastName" type="xs:string" use="optional" />

    <xs:attribute name="city" type="xs:string" use="optional" />

    <xs:attribute name="state" type="xs:string" use="optional" />

    <xs:attribute name="phone" type="xs:string" use="optional" />







  • I know it's more complicated than a Hello World. I had it simpler the first version, but the editor wanted more.

    To me the important part is just getting the XML Source to work. Once you know how to do that, the rest is just stuff you've already been doing in SSIS.

    It took me a while to even figure out that the XML Source existed.

Viewing 12 posts - 16 through 26 (of 26 total)

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