Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 xml breakdown

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-06-30 : 04:59:26

I've seen the 5 basic DBA commands you can use to read / change xml...

I can't stand xml!!

How can I use SSIS to read my iTunes.xml file (Windows or Mac) to prepare it for reporting on the metadata - counting, categorising and aggregation (I can do all of that) but I've tried this, and SSIS is no good...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-06-30 : 05:48:49
Seen this?
http://sqlblog.com/blogs/peter_debetta/archive/2006/12/05/iPod-and-iTunes-Parsing-the-XML-Library.aspx



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -