SQL Server Integration Services
Copyright © 2007 O'Reilly Media, Inc.
March 29, 2007
Abstract
SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources.
This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS).
Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios.
Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.
SQL Server Integration Services (SSIS) is a platform for building high-performance data integration and workflow business applications that include extract, transformation, and load (ETL) functionality.
Some things you can do with SSIS include:
Access a variety of data using .NET or OLE DB data providers and ODBC drivers.
Connect to flat files, Excel spreadsheets, XML documents, Analysis Services projects, and relational databases.
Access data archived in legacy systems, different storage technologies, and data with different schemas.
Take heterogeneous data from a variety ...
Get SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
