Saturday, November 28, 2009

Do you need to send data in XML? Use SQL Server Integration Services

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:

No comments: Protection Status