Welcome!

XML Authors: Lori MacVittie, Martin Ingram, Tong Liu, Gilad Shainer, Brian Sparks

Related Topics: .NET, XML

.NET: Blog Feed Post

Using SQL Server Integration Services

Extract data in XML from your database using a stored procedure and persist it to the file system
By Jayaram Krishnaswamy
Article Rating:
November 29, 2009 12:45 AM EST
Reads:
 733

Integrating data into applications or reports is one of the most important, expensive and exacting activities in building enterprise data warehousing and reporting applications.

SQL Server Integration Services which first appeared in MS SQL Server 2005 and continued into MS SQL Server 2008 provides a one-stop solution to the ETL Process. The ETL Process consists of extracting data from a data source, transforming the data so that it can get in cleanly into the destination followed by loading the transformed data to the destination.

Enterprise data can be of very different kinds ranging from flat files to data stored in relational databases. Recently storing and exchanging data in XML  has become common as exchanging data in XML format has many advantages.

This article describes how you may extract data in XML from your database using a stored procedure and persist it to the file system in either XML or text formats using Microsoft SQL Server Integration Services.

Writing XML data to the File System with SSIS

You may also want to read these recent articles on SSIS:

MySQL Data Transfer using SQL Server Integration Services (SSIS)

Ground to SQL Azure migration using MS SQL Server Integration Services

Read my book and get a handle on many other package tasks:

Read the original blog entry...

Published November 29, 2009 – Reads 733
Copyright © 2009 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His recent book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. He writes articles on several topics to many sites.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.