SSIS Succinctly

Morrisville, Syncfusion Inc, 2014. — 116 p. This book is for all developers who want to enrich their knowledge about extract, transform, and load operations (ETL) using SQL Server Integration Services. Although the main targets are developers, every information systems professional will be able to understand how Integration Services works and how to use it to develop ETL processes. This is a book based in the visual environment (SQL Server Data Tools or SSDT) and is designed to be easy to use and understand. Contents: The Story behind the Succinctly Series of Books About the Author Who is This Book For? Introduction Integration Services Architecture Introduction Explaining the Components Runtime Engine Integration Services Service SSIS Designer Log Provider Connection Manager SSIS Wizard Packages Tasks Event Handlers Containers Control Flow Data Flow Engine Project and Package Deployment Models Developer Environment Introduction SSIS Designer Packages 4Introduction Hello World Package—Import and Export Wizard Custom Packages Introduction Adding a New Package to a Project Executing the Packages Package Explorer Package Properties Checkpoints Execution Forced Execution Value Identification Misc Transactions Version The Story behind the Succinctly Series of Books 8 About the Author 10 Who is This Book For? 11 Introduction 12 Chapter 1 Integration Services Architecture 13 Introduction 13 Explaining the Components 14 Runtime Engine 14 Integration Services Service 14 SSIS Designer 14 Log Provider 14 Connection Manager 15 SSIS Wizard 15 Packages 15 Tasks 15 Event Handlers 15 Containers 15 Control Flow 16 Data Flow Engine 16 Project and Package Deployment Models 16 Developer Environment 17 Introduction 17 SSIS Designer 18 Chapter 2 Packages 20 Introduction 20 Hello World Package—Import and Export Wizard 20 Custom Packages 26 Introduction 26 Adding a New Package to a Project 26 Executing the Packages 27 Package Explorer 29 Package Properties 30 Checkpoints 31 Execution 32 Forced Execution Value 32 Identification 32 Misc 32 Security 33 Transactions 33 Version 33 Chapter 3 Control Flow 34 Introduction 34 Tasks and Containers 35 Introduction 35 Favorite Tasks 36 Common 37 Containers 39 Other Tasks 40 Precedence Constraints 43 Introduction 43 Advanced Precedence Constraints 45 Connection Managers 47 Introduction 47 Add a Connection Manager at a Solution Level 47 Add a Connection Manager at a Package Level 48 Available Connection Managers 48 Creating a New OLE Database (SQL Server Connection) 49 Fix: Excel/Access Connection Manager Error When Running Package in 64-bit Environment 53 Event Handlers 55 Introduction 55 Using Event Handlers 55 Troubleshooting 56 Breakpoints 57 Using Breakpoints to Stop Before Executing a Task 58 Logging 59 Activate Logging in Your Packages 59 Creating a Simple Control Flow 62 Chapter 4 Data Flow 65 Introduction 65 Favorites 66 Common 67 Other Transforms 69 Other Sources 71 Other Destinations 72 Data Viewers 73 Introduction 73 Using Data Viewers 73 Creating a Simple Data Flow 74 Introduction 74 Creating the Data Flow 75 Chapter 5 Variables, Expressions, and Parameters 80 Introduction 80 Understanding the components 80 Creating New Variables 81 Creating New Expressions 81 Creating New Parameters 82 Handling Slowly Changing Dimensions 83 Introduction 83 Demo: Using the Slowly Changing Dimension Component 83 Change Data Capture 92 Introduction 92 Demo: Using CDC in an ETL Project 94 Enable CDC on the Database 95 Enable the SQL Agent in the Server of the CDC 95 Enable CDC in the Tables We Want to Monitor for Changes 97 Process the Changed Data in SSIS and Use the SSIS CDC Component to Make It Easier 101 Process Initial Load 101 Create the CDC Data Flow 104 Chapter 6 Deploying the Packages 109 Introduction 109 Project Deployment Model 110 Package Deployment Model 114 ETL,business intelligence,BI,Microsoft,Syncfusion,Succinctly series,sql server,sql server integration services Learn to develop data integration, migration, and consolidation projects in SSIS.