Creating an XML Data Source and Dataset in SSRS

Join SQL MVP Jessica Moss as she uses Reporting Services 2008 to pull data from an XML file.

Jessica M. Moss, a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integratio...

Jessica Moss on 7/30/2009

For related videos, please search for "reporting services" in the search box on Jumpstart TV.

Donna Shaver on 8/11/2009

Very well done! (Hi Jessica!)

michael on 8/11/2009

Thanks.. I didn't realize that you could do this!

Ahmad Elayyan on 8/11/2009

good

Prasanna Prabhu on 8/11/2009

You created a "Shared Data Source" "http://localhost:...." using wizard option. If we need to deploy this package to another server (say "Production" server) how do we change the XML configuration value to something like "http://productionserverurl:....". Information like these are always informational

Ivan on 8/11/2009

3 Minutos were not enought

Joe Pattison on 8/13/2009

Thanks for the great information on Reporting services!

kana alexander on 8/14/2009

Thanks, great demo

Jessica Moss on 8/15/2009

Hi Prasanna, Your shared data source would be unique per server, so you would create it once. You would not need to modify it when you upload reports through your environments. -Jessica

James Allen on 8/17/2009

Useful.

CK Park on 8/21/2009

Great

Charlie on 8/21/2009

Excellent! We should more videos like this in the site.

rupesh sharma on 9/11/2009

very good

Garth on 9/14/2009

Simply great - so clear and easy to understand, thanks!

Tonci on 10/23/2009

You are awesome at explaining. Thank you. Really good explanation if you base a report on output of a web service call. Great!

Bob Holmboe on 11/2/2009

Needs to follow through to the report.

Ken on 11/3/2009

short

Steve Culshaw on 11/6/2009

cool, basing reports on XML

muthuvel on 11/26/2009

good

raj on 12/8/2009

good

SQLExpert on 2/20/2010

nice one

Dean Gross on 10/13/2010

thanks, this was a totally new data source for me and it was explained very clearly.

Paul E Richmond on 6/7/2011

I would LOVE to see an example where you pass in XML data from an XML column selected in an SQL data source. (I am assuming you would pass it into a sub-report and do the XML parsing thing there....)

manjunath on 9/11/2011

Some more explanation on why we use and scenario would have been a great help. Anyway thanks for your video.

sam.msbi on 12/30/2011

could have provide us more complex example.. but okay still it is good

Sasi on 1/6/2012

Good one

Lam Tran on 1/6/2012

Excellent

John Snyder on 1/6/2012

It would be nice to see the results in the example

Max Turavani on 1/6/2012

nice. good intro to using xml in ssrs

Greg Joiner on 1/6/2012

Need a basic start of what the video is going to do and 'why' to clarify.

Wai Chung on 1/6/2012

Good!

Kerrie on 1/6/2012

It was ok for someone that is very new to the XML datasoruce.

George Squillace on 1/6/2012

I would have liked a bit more detail about the code entered into the query window, and a bit more detail about valid connection strings that are supported for XML. For instance, are HTTP URLs the only supported connection string or are there others. Thank you for the presentation...I definitely learned from it.

Paul E Richmond on 1/6/2012

Would have liked to see an example driven from an SQL xml column.

John O'Sullivan on 1/6/2012

good xml tip

Kioumars Pournaghdi on 1/6/2012

Good stuff. Thanks

Moe on 1/7/2012

Excellent video. Very useful. Thanks!

Steve Harris on 1/20/2012

Need better explanation on how the catalog{}/Book configuration works. Maybe show how it relates in the source.

Michael on 2/1/2012

Very Nice Example

saipramod on 7/20/2012

very clear explanation...thanks!