Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

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.

Architecture

SSIS consists of four key parts:

Integration Services service

Manages storage of packages and monitors running Integration Services packages.

Integration Services object model

Comprises native and managed APIs for accessing Integration Services tools, command-line utilities, and custom applications.

Integration Services runtime

Saves the layout of packages, runs packages, and supports logging, breakpoints, configuration, connections, and transactions. SSIS runtime executables are the packages, containers, tasks, and event handlers that perform workflow functionality.

Data flows

Move data from source to destination with optional transformation. There are three types of data-flow components—source, transformation, and destination ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page