Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Hello SSIS World, From XML! Expand / Collapse
Author
Message
Posted Monday, April 12, 2010 10:43 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:36 PM
Points: 128, Visits: 916
Comments posted to this topic are about the item Hello SSIS World, From XML!
Post #902124
Posted Tuesday, April 13, 2010 1:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:14 AM
Points: 3, Visits: 112
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
Post #902169
Posted Tuesday, April 13, 2010 2:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 30, 2014 3:58 PM
Points: 2, Visits: 28
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
Post #902191
Posted Tuesday, April 13, 2010 2:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:48 AM
Points: 49, Visits: 541
Looks really good but I can't find the dtsx either,

Rog
Post #902192
Posted Tuesday, April 13, 2010 3:33 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:41 AM
Points: 527, Visits: 485
Could not find the XmlSourceDemo.dtsx package
Post #902229
Posted Tuesday, April 13, 2010 6:27 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:37 AM
Points: 697, Visits: 350
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
Post #902331
Posted Tuesday, April 13, 2010 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:59 AM
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!
Post #902355
Posted Tuesday, April 13, 2010 7:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:36 PM
Points: 128, Visits: 916
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
Post #902358
Posted Tuesday, April 13, 2010 7:11 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
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


--
Post #902364
Posted Tuesday, April 13, 2010 7:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:18 AM
Points: 31,078, Visits: 15,522
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
Post #902378
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse