Book description
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.
Table of contents
-
SQL Server Integration Services
- Getting Started
- Installation and Setup
- Key Concepts
- Developing Solutions
- Executing Packages
- Deploying Packages
- Migrating from Legacy
- Example 1: Data Flow
- Example 2: Aggregation
- Example 3: Lookup
- Example 4: Data Type Conversion
- Example 5: Variables
- Example 6: Package Configuration
- Example 7: Looping and Control Flow
- Example 8: Logging
- Example 9: Error Handling
- About the Author
Product information
- Title: SQL Server Integration Services
- Author(s):
- Release date: March 2007
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596557706
You might also like
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 3rd Edition
Through a recent series of breakthroughs, deep learning has boosted the entire field of machine learning. …
book
Microsoft SQL Server 2016 Reporting Services, Fifth Edition, 5th Edition
Up-to-Date Coverage of Microsoft® SQL Server® 2016 Reporting Services, Including the Mobile Report Publisher Build, publish, …
book
Python for Excel
While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests …
book
Python for Data Analysis, 3rd Edition
Get the definitive handbook for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python …