Solved

XML Spreadsheet import using SSIS 2008

Posted on 2012-03-27
1
774 Views
Last Modified: 2012-04-24
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.
0
Comment
Question by:SQLDBUSER
1 Comment
 
LVL 10

Accepted Solution

by:
pfrancois earned 500 total points
ID: 37773448
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question