THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Dejan Sarka

SQL Server 2017 Integration Services Cookbook

I coauthored my 15th bookSmile Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name would be SSIS 2016 / 2017 Cookbook. Besides detailed guidelines how to use the 2016 version, you will also find a chapter on some new information on scaling out SSIS 2017. In the future, we will add an online chapter, if it will be needed, about additional new SSIS 2017 functionalities. Anyway, here is a brief description of the chapters.

Chapter 1: SSIS Setup

This chapter will describe step by step how to setup SQL Server 2016 to get the features that are used in the book.

Chapter 2: What is New in SSIS 2016

This chapter is an overview of Integration Services 2016 new features. Some of the topics covered here are covered extensively later in the book.

Chapter 3: Key Components of a Modern ETL Solution

This chapter will explain how ETL has evolved over the past few years and will explain what components are necessary to get a modern scalable ETL solution that fits the modern data warehouse.

Chapter 4: Data Warehouse Loading Techniques

This chapter describes many patterns used when it comes to data warehouse (DW) or operational data store (ODS) load.

Chapter 5: Dealing with Data Quality

This chapter will describe how SSIS, DQS and MDS can be leveraged to validate, cleanse, maintain, and load data.

Chapter 6: SSIS Performance and Scalability

This chapter talks about how to monitor SSIS package execution. It also provides solutions to scale out processes by using parallelism. Readers learn how to identify bottlenecks and how to resolve them using various techniques.

Chapter 7: Unleash the Power of SSIS Script Task and Component

Readers learn how script tasks and script components are very valuable in many situations to overcome the limitations of stock toolbox tasks and transforms.

Chapter 8: SSIS and Advanced Analytics

This chapter talks about using SSIS to prepare data for and do advanced analyses like data mining, machine learning, and text mining. Readers learn how sampling components can be used for preparing the training and the test set, how to use SQL Server Analysis Services data mining models, how to execute R code inside SSIS, and how to analyze texts with SSIS.

Chapter 9: On-Premises and Azure Big Data Integration

This chapter talks about the Azure Feature pack that allows SSIS to integrate Azure data from blob storage and HDInsight clusters. Readers learn how to use Azure feature pack components to add flexibility to their SSIS solution architecture.

Chapter 10: Extending SSIS Custom Task and Transformations

This chapter talks about extending and customize the toolbox using custom developed tasks and transforms.

Chapter 11: Scale Out with SSIS 2017

The last chapter is dedicated to SSIS 2017 and teaches you how to scale out SSIS package executions on multiple servers.

Enjoy the reading!

Published Friday, July 14, 2017 1:42 PM by Dejan Sarka

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Dejan Sarka

Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database & business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of fourteen books about databases and SQL Server. Dejan Sarka also developed and is developing many courses and seminars for SolidQ, Microsoft and Pluralsight. He is a regular speaker at many conferences worldwide for more than 15 years, including conferences like Microsoft TechEd, PASS Summit and others.

This Blog


Privacy Statement