Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Hello SSIS World, From XML!


Hello SSIS World, From XML!

Author
Message
Stan Kulp-439977
Stan Kulp-439977
Old Hand
Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)

Group: General Forum Members
Points: 380 Visits: 1107
Comments posted to this topic are about the item Hello SSIS World, From XML!
alan.murray
alan.murray
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 125
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
cedric.devroey
cedric.devroey
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 31
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
roger_os
roger_os
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 568
Looks really good but I can't find the dtsx either,

Rog
arvindravish
arvindravish
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 568
Could not find the XmlSourceDemo.dtsx package Hehe
Deepak Sharma-2311
Deepak Sharma-2311
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 Visits: 458
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
Brad Roberts-480600
Brad Roberts-480600
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 15
OK, where is the dtsx? Are you going to post this and make me do it myself? You are pushing a button this time!
Stan Kulp-439977
Stan Kulp-439977
Old Hand
Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)

Group: General Forum Members
Points: 380 Visits: 1107
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
Slick84
Slick84
Mr or Mrs. 500
Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)Mr or Mrs. 500 (516 reputation)

Group: General Forum Members
Points: 516 Visits: 1163
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
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: Administrators
Points: 41636 Visits: 18876
The dtsx is now attached to the article.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search