Solved

XML Spreadsheet import using SSIS 2008

Posted on 2012-03-27
1
778 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

740 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