cta quote button

Best SSIS Books to Master the Technology

Read More

How Much Does It Cost to Hire Web Developers in Ukraine?

Our pricing is completely transparent: you pay your engineers’ salaries and a flat monthly fee for our services. No hidden charges.

Read More

1. Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) (2014)

Fill the gap between planning and doing with SSIS 2014

The 2014 release of Microsoft’s SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage.

  • Implement new best practices for effective use of SSIS
  • Work through tutorials for hands-on learning of complex techniques
  • Read case studies that illustrate the more advanced concepts
  • Learn directly from the foremost authority on SSIS

SQL Server Integration Services is a complex tool, but it’s the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

Author(s): Brian Knight, Devin Knight

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

Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BI

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 tools. The book includes coverage of self-service business intelligence with Power BI.

• Understand the goals and components of successful BI
• Build data marts, OLAP cubes, and Tabular models
• Load and cleanse data with SQL Server Integration Services
• Manipulate and analyze data using MDX and DAX scripts and queries
• Work with SQL Server Analysis Services and the BI Semantic Model
• Author interactive reports using SQL Server Data Tools
• Create KPIs and digital dashboards
• Implement time-based analytics
• Embed data model content in custom applications using ADOMD.NET
• Use Power BI to gather, model, and visualize data in a self-service environment

Author(s): Brian Larson

3. 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). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the “Standard”, “Business Intelligence” and “Enterprise” editions. This updated and expanded second edition of Book provides a user-friendly introduction to the subject, Taking a clear structural framework, it guides the reader through the subject’s core elements. A flowing writing style combines with the use of illustrations and diagrams throughout the text to ensure the reader understands even the most complex of concepts. This succinct and enlightening overview is a required reading for all those interested in the subject . We hope you find this book useful in shaping your future career & Business.

Author(s): Charles Brown

4. 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. First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the “Standard”, “Business Intelligence” and “Enterprise” editions. This updated and expanded second edition of Book provides a user-friendly introduction to the subject, Taking a clear structural framework, it guides the reader through the subject’s core elements. A flowing writing style combines with the use of illustrations and diagrams throughout the text to ensure the reader understands even the most complex of concepts. This succinct and enlightening overview is a required reading for all those interested in the subject . We hope you find this book useful in shaping your future career & Business.

Author(s): Nicole Lyons

5. 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. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.

SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.

  • Provides a timeless scripting toolkit for all current SSIS versions
  • Gives a comprehensive explanation of scripting in SSIS
  • Offers a wide array of readymade examples for everyday problems

    Author(s): Joost van Rossum, Regis Baccaro

    6. Professional Microsoft SQL Server 2012 Integration Services (2012)

    An in-depth look at the radical changes to the newest release of SISS

    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). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.

    • Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
    • Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
    • Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques

    Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.

    Author(s): Brian Knight, Erik Veerman

    7. 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. These gaps are especially relevant to enterprises practicing Data Integration Lifecycle Management (DILMS) and/or DevOps. 
    One of the gaps is a limitation of the SSIS Execute Package task. Developers using the stock version of that task are unable to select SSIS packages from other projects. Yet it’s useful to be able to select and execute tasks across projects, and the example used throughout this book will help you to create an Execute Catalog Package task that does in fact allow you to execute a task from another project. Building on the example’s pattern, you can create any task that you like, custom tailored to your specific, data integration and ETL needs.
    What You Will Learn
    • Configure and execute Visual Studio in the way that best supports SSIS task development
    • Create a class library as the basis for an SSIS task, and reference the needed SSIS assemblies
    • Properly sign assemblies that you create in order to invoke them from your task
    • Implement source code control via Visual Studio Team Services, or your own favorite tool set
    • Code not only your tasks themselves, but also the associated task editors
    • Troubleshoot and then execute your custom tasks as part of your own project
    Who This Book Is For

    Database administrators and developers who are involved in ETL projects built around SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their ETL efforts by creating custom-tailored tasks for execution from SSIS packages.

    Author(s): Andy Leonard

    8. 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. The book is written for the novice user, so there is no requirement for previous experience of working with MS SQL Server and other tools. However, it expects readers to know basics of databases like the table, columns, etc. The book does not aim to teach data warehousing multi-dimensional design principle, nor play the role of a comprehensive reference book on Microsoft Business Intelligence Toolset. It only intends to help readers to gets a hands-on experience on data warehouse development quickly. It aims to give readers basic understanding and experience, so they become more confident in using reference books and online materials. The book does not go through the installation of tools that are used in the sample project. The readers need to install the following tools in order to follow the steps, i.e., Microsoft SQL Server Database Engine, Microsoft SQL Server Integration Services (SSIS) 2017, Microsoft SQL Server Analysis Services (SSAS) 2017, Microsoft SQL Server Management Studio (SSMS), Microsoft Excel, and Microsoft Power BI.

    Author(s): Dr. Amin Jalali

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

    Book-and-video package gets novices up to speed on Microsoft SQL Server 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.

    • Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)
    • Provides expert instruction from leading SQL Server authority and author, Brian Knight
    • Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author
    • Covers the very latest changes and updates in the SQL Server 2012 release

    Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.

    Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

    Author(s): Brian Knight, Devin Knight

    10. 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. You’ll learn how scripting in SQL Server Integration Services can enable you to easily add new, fully-integrated functionality to achieve your enterprise data integration needs.

    This book takes a rational, no-nonsense approach in a compact guide – only 224 pages. The book is written to give you the basics…fast!

    Technical Accuracy is assured by Ashvini Sharma, Development Lead, SQL Server Integration Services, Microsoft Corporation.

    * Bonus Chapter: “Monitoring SSIS Performance with Scripts”
    * Bonus Chapter: “Accessing Web Services with SSIS Scripts”
    * Bonus Chapter: “Using SSIS as a Data Service”
    * Sample code for the examples in the book

    Author(s): Donald Farmer

    11. SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert’s Voice in SQL Server) (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. You’ll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You’ll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

    What DBA or developer isn’t faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft’s flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you’re looking for a resource to cover data integration and ETL across the gamut of Microsoft’s SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.

    • Provides practical and proven solutions towards creating resilient ETL environments
    • Clearly answers the tough questions which professionals ask
    • Goes beyond the tools to a thorough discussion of the underlying techniques
    • Covers the gamut of data integration, beyond just SSIS
    • Includes example databases and files to allow readers to test the recipes

    Author(s): Adam Aspin

    12. 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. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face. The book’s team of expert authors take you through numerous design patterns that you’ll soon be using every day, providing the thought process and technical details needed to support their solutions.

    SQL Server Integration Services Design Patterns goes beyond the surface of the immediate problems to be solved, delving into why particular problems should be solved in certain ways. You’ll learn more about SSIS as a result, and you’ll learn by practical example. Where appropriate, the book provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, Business Intelligence Markup Language, and Dependency Services.

    • Takes you through solutions to common data integration challenges
    • Provides examples involving Business Intelligence Markup Language
    • Teaches SSIS using practical examples

    Author(s): Tim Mitchell, Matt Masson