Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Over 80 expert recipes to design, create, and deploy SSIS packages

• Full of illustrations, diagrams, and tips with clear step-by-step instructions and real time examples
• Master all transformations in SSIS and their usages with real-world scenarios
• Learn to make SSIS packages re-startable and robust; and work with transactions
• Get hold of data cleansing and fuzzy operations in SSIS

In Detail

SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load operations. This book is aligned with the most common methodology associated with SSIS known as Extract Transform and Load (ETL); ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart.

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook covers all the aspects of SSIS 2012 with lots of real-world scenarios to help readers understand usages of SSIS in every environment.

Written by two SQL Server MVPs who have in-depth knowledge of SSIS having worked with it for many years.

This book starts by creating simple data transfer packages with wizards and illustrates how to create more complex data transfer packages, troubleshoot packages, make robust SSIS packages, and how to boost the performance of data consolidation with SSIS. It then covers data flow transformations and advanced transformations for data cleansing, fuzzy and term extraction in detail. The book then dives deep into making a dynamic package with the help of expressions and variables, and performance tuning and consideration.

What you will learn from this book

• Step-by-step instructions to create Data Flow; and working with different sources and destinations
• Focus on some best practices for raising the performance of packages and data flow
• Understand Containers and Loop structures in SSIS
• Explore all the aspects of event handlers in SSIS
• Gain knowledge to debug, troubleshoot, and migrate packages
• Master the different ways to deploy and execute packages

Approach

This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations.

Who this book is written for

If you are an SQL database administrator or developer looking to explore all the aspects of SSIS and need to use SSIS in the data transfer parts of systems, then this is the best guide for you. Basic understanding of working with SQL Server Integration Services is required.

超過80個專家食譜，用於設計、創建和部署SSIS封包
充滿插圖、圖表和提示，並提供清晰的逐步指示和實時示例
掌握SSIS中的所有轉換及其在實際場景中的使用
學習使SSIS封包可重新啟動和強大，並處理交易
掌握SSIS中的數據清理和模糊操作
詳細內容
SQL Server Integration Services（SSIS）是數據倉庫行業中的領先工具，用於執行提取、轉換和加載操作。本書與SSIS最常見的方法論Extract Transform and Load（ETL）相一致；ETL負責從多個來源提取數據，對其進行清理、定制和加載到通常稱為數據倉庫或數據馬特的中央存儲庫中。

Microsoft SQL Server 2012 Integration Services：An Expert Cookbook涵蓋了SSIS 2012的所有方面，並提供了許多實際場景，以幫助讀者了解SSIS在各種環境中的用途。

本書由兩位深入了解SSIS的SQL Server MVP撰寫，他們多年來一直與SSIS合作。

本書首先通過使用精靈創建簡單的數據傳輸封包，並演示如何創建更複雜的數據傳輸封包，排除故障封包，創建強大的SSIS封包，以及如何通過SSIS提高數據合併的性能。然後，詳細介紹數據流轉換和數據清理、模糊和術語提取的高級轉換。本書還深入探討了如何通過表達式和變量創建動態封包，以及性能調優和考慮因素。

從本書中學到的內容
逐步指示創建數據流；以及使用不同來源和目的地
專注於提高封包和數據流性能的一些最佳實踐
了解SSIS中的容器和循環結構
探索SSIS中事件處理程序的所有方面
獲得調試、故障排除和遷移封包的知識
掌握部署和執行封包的不同方式

方法
本書以簡單易懂的格式撰寫，並附有大量截圖和逐步解釋。

本書的讀者
如果您是SQL數據庫管理員或開發人員，希望探索SSIS的所有方面並需要在系統的數據傳輸部分使用SSIS，那麼這是您的最佳指南。需要基本了解如何使用SQL Server Integration Services。