XML Spreadsheet import using SSIS 2008

I get what appears to be an ".xls" file from a third party vendor, and need to import data from two of the tabs, but I've come to realize, it's actually a "XML Spreadsheet".  I need to figure out a way to import it into out SQL Database tables.  Any help would be appreciated.
SQLDBUSERAsked:
Who is Participating?
 
Pierre FrançoisConnect With a Mentor Senior consultantCommented:
XSLT is a programming language for transforming XML files into whatever, even a plain text file. If the conversion you need is frequent, write an XSLT program and process it with xsltproc or whatever that understands XSLT and produce the corresponding SQL.
0
All Courses

From novice to tech pro — start learning today.