Chapter 15. SQL Server Integration Services (SSIS)


SQL Server Integration Services (SSIS) is a platform for building data integration and workflow solutions and extract, transform, and load (ETL) solutions for data warehousing. Common integration scenarios include merging data from heterogeneous data sources, populating data warehouses and data marts, standardizing data, and performing administrative functions such as backing up, copying, and loading data.

SQL Server 2005 provides graphical tools for constructing data integration solutions. You can also construct, maintain, manage, and run data integration programmatically using either native or managed code. This chapter provides an overview of SSIS and demonstrates SSIS managed-code programming.



Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net