Post reply

Hello SSIS World, From XML!

  • April 12, 2010 at 10:43 pm

    #233870

    Comments posted to this topic are about the item Hello SSIS World, From XML!

  • April 13, 2010 at 1:12 am

    #1150517

    posting here also....

    the article states

    Add the attached XmlSourceDemo.dtsx file to an SSIS project as an existing package.

    I can't seem to find the XmlSourceDemo.dtsx file... anybody help.???

    Thanks

  • April 13, 2010 at 2:21 am

    #1150535

    Hi Guys,

    This article is Okay but I think a sequel wouldn't be of any harm since all who works with SSIS often knows that XML processing isn't always as straight-forward as it is shown in the tutorial here. What when there are multiple namespaces (and yes 99% of the time this is the case)? How do you generate your XSD then? What when you get an XSD but the location is variable?

    You see, still a lot of room for writing some more advanced tutorials.

    Kind regards,

    Cedric De Vroey

    Cedric is a Business Intelligence Consultant at Numius NV. Numius is an IBM Cognos partner based in Belgium that is specialized in Corporate Performance Management and Business Intelligence. Come visit us at www.numius.eu

  • April 13, 2010 at 2:22 am

    #1150536

    Looks really good but I can't find the dtsx either,

    Rog

  • April 13, 2010 at 3:33 am

    #1150565

    Could not find the XmlSourceDemo.dtsx package :hehe:

  • April 13, 2010 at 6:27 am

    #1150650

    Me also could not find the .dtsx file, but I make it by my own after viewing the screen shots with this article. Really nice article.

    Deepak Kumar Sharma

  • April 13, 2010 at 6:58 am

    #1150672

    OK, where is the dtsx? Are you going to post this and make me do it myself? You are pushing a button this time!

  • April 13, 2010 at 7:04 am

    #1150674

    I don't know why the source file is not attached. I emailed the webmaster with a copy.

    You can download it at this link:

    http://www.box.net/shared/yooun9a88z

  • April 13, 2010 at 7:11 am

    #1150680

    Thanks for the article.

    Even though it seems very straight forward & simple , it really isnt because the XML source adapter does not always function as you would want it to.

    With simple XSD's as provided in the example, it definitely is as straight forward but in real life situations, many times the XSD's are much more complicated with child elements and such.

    After relentlessly trying to make it work through SSIS, I had to resort to TSQL Xquery (using OPENROWSET) which I found out about on these forums through Lutz. I believe it is much more easier and flexible.

    Anyhow, good write-up.

    Thanks,

    Slick

    --
    :hehe:

  • April 13, 2010 at 7:18 am

    #1150694

    The dtsx is now attached to the article.

  • April 13, 2010 at 7:22 am

    #1150695

    The source file is still not attached.

    You can get it here:

    http://www.box.net/shared/yooun9a88z

  • April 13, 2010 at 9:25 am

    #1150811

    Someone should thank you, so I am doing so now.

  • April 13, 2010 at 9:38 am

    #1150818

    Its there now.. Good article... Thanks... wouold be happy to see more. Finally getting into SSIS after a long and faithful use of DTS 🙂

    cheers

  • April 13, 2010 at 9:38 am

    #1150819

    Hey Steve,

    I tried adding the .dtsx to a project and it doesnt load indicates it's the wrong XML format, any ideas ?

    I tried opening it in an XML editor and received the same error, however it opens in notepad fine.

    Thoughts ?

    Dave Fraser

    😎

  • April 13, 2010 at 9:45 am

    #1150822

    The file attached to this article has been corrupted.

    The file on box.net is a good file.

    http://www.box.net/shared/yooun9a88z

Viewing 15 posts - 1 through 15 (of 26 total)

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