📚 Book Lovin' Geek Mamas are on a mission to promote a love of books and reading to everyone. We help our visitors to find their next favorite book. Our authors regularly create and post so-called listicles (also known as booklists) on various mostly tech-related topics.

Best SSIS Books To Master The Technology

In this post, we have prepared a curated top list of reading recommendations for beginners and experienced. This hand-picked list of the best Ssis books and tutorials can help fill your brain this October and ensure you’re getting smarter. We have also mentioned the brief introduction of each book based on the relevant Amazon or Reddit descriptions.

Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition (2016)

Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client
Author(s): Brian Larson

SSIS Easy Handbook (2016)

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL).
Author(s): Charles Brown

SSIS In a Day (2016)

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
Author(s): Nicole Lyons

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services (2015)

Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter.
Author(s): Joost van Rossum, Regis Baccaro

Professional Microsoft SQL Server 2012 Integration Services (2012)

Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL).
Author(s): Brian Knight, Erik Veerman

Building Custom Tasks for SQL Server Integration Services (2017)

Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. If you already have a license for SQL Server, then you do not need to spend more money to extend SSIS with custom tasks and components. Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, there do remain gaps in the functionality that is provided. 
Author(s): Andy Leonard

The Data Warehouse Lab: A step-by-step guide using SSIS and SSAS 2017 (2017)

This book aims to help students and practitioners who are new to data warehousing to start developing a new data warehouse project from scratch. It shows different phases of data warehousing projects through a simple case. So readers can experience the full data warehouse development life-cycle through a simple example step-by-step. 
Author(s): Dr. Amin Jalali

Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer (2012)

If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It’s a complete learning package that will give you the confidence you need to start your first SSIS project.
Author(s): Brian Knight, Devin Knight

The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) (2007)

The Integration Services feature of Microsoft® SQL Server 2005 brings together data from diverse sources in a high-performance data integration platform, to enable users to work across multiple applications that may not have been designed to cooperate. In this book, Donald Farmer, Microsoft’s Group Program Manager for SQL Server Integration Services, clearly explains how to build practical and useful scripts for this exciting new SQL Server 2005 feature. His systematic approach, friendly tutorials, and numerous examples are suitable for both developers and IT professionals alike.
Author(s): Donald Farmer

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services  (2012)

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back.
Author(s): Adam Aspin

SQL Server Integration Services Design Patterns (2014)

SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions.
Author(s): Tim Mitchell, Matt Masson

You might also be interested in: Bitcoin, ADO.NET, ABAP, Numpy, Augmented Reality, Kubernetes, CSS, Haskell, ERP, JQuery Books.

Best SSIS Books to Master the Technology

We highly recommend you to buy all paper or e-books in a legal way, for example, on Amazon. But sometimes it might be a need to dig deeper beyond the shiny book cover. Before making a purchase, you can visit resources like Library Genesis and download some Ssis books mentioned below at your own risk. Once again, we do not host any illegal or copyrighted files, but simply give our visitors a choice and hope they will make a wise decision.

SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory

Author(s): Andy Leonard, Kent Bradshaw
ID: 2876938, Publisher: Apress, Year: 2020, Size: 18 Mb, Format: pdf

Data Integration Life Cycle Management with SSIS: A Short Introduction by Example

Author(s): Andy Leonard
ID: 2152507, Publisher: Apress, Year: 2018, Size: 10 Mb, Format: pdf

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services

Author(s): Joost van Rossum, Régis Baccaro
ID: 1406788, Publisher: Apress, Year: 2015, Size: 19 Mb, Format: pdf

Please note that this booklist is not final. Some books are absolutely best-sellers according to Washington Post, others are written by unknown writers. On top of that, you can always find additional tutorials and courses on Coursera, Udemy or edX, for example. Are there any other relevant links you could recommend? Drop a comment if you have any feedback on the list.

Rate article
Add a comment

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: