March 2007
Beginner to intermediate
88 pages
1h 52m
English
Content preview from SQL Server Integration ServicesBecome 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,
Start your free trial
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 ...