
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
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 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 Get to grips with all th
This book provides practical, step-by-step recipes for designing, creating, and deploying SQL Server Integration Services (SSIS) 2012 packages. It addresses the core Extract, Transform, and Load (ETL) methodology, essential for data warehousing, by detailing how to extract data from various sources, cleanse and transform it, and load it into a central repository. The content is structured around real-world scenarios and expert insights from SQL Server MVPs, aiming to equip readers with the skills to build robust, efficient, and dynamic SSIS solutions.
This book is designed as a practical guide for professionals working with SQL Server Integration Services, offering a collection of expert recipes to master SSIS 2012. The content focuses on real-world applications and best practices, aiming to enhance the reader's ability to handle data extraction, transformation, and loading efficiently. The inclusion of detailed instructions, diagrams, and scenarios suggests a focus on hands-on learning for database professionals and administrators.
Page Count:
564
Publication Date:
2012-01-01
Publisher:
Packt Publishing
ISBN-10:
1849685258
ISBN-13:
9781849685252
No comments yet. Be the first to share your thoughts!