SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved.

Consuming a Header Row.

Title Page; Copyright Page; Contents at a Glance; Table of Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; CHAPTER 1 Metadata Collection; Introducing SQL Server Data Tools; A Peek at the Final Product; SQL Server Metadata; Setting Up the Central Repository; The Iterative Framework; Metadata Collection; Summary; CHAPTER 2 Execution Patterns; Building the Demonstration SSIS Package; Debug Execution; Command-Line Execution; Execute Package Utility; The SQL Server 2012 Integration Services Service; Integration Server Catalogs.

Integration Server Catalog Stored ProceduresAdding a Data Tap; Creating a Custom Execution Framework; Scheduling SSIS Package Execution; Scheduling an SSIS Package; Scheduling a File System Package; Running SQLAgent Jobs with the Custom Execution Framework; Running the Custom Execution Framework with SQL Agent; Metadata-Driven Execution; Execution from Managed Code; The Demo Application; The frmMain Form; Summary; CHAPTER 3 Scripting Patterns; The Toolset; Should I Use Script?; The Script Editor; Project Explorer; Full .NET Runtime; Compiler; The Script Task; The Script Component.

Script Maintenance PatternsCode Reuse; Co…