Book

SQL Server 2017 Integration Services Cookbook

SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of this book, you’ll gain complete hands-on experience of SSIS 2017’s new features, and design and development improvements including SCD, Profiling, Tuning, and Customizations.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

18h36m

Language

English

About Book

Who Is This Book For?

This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017.

Book content

chapters 18h36m total length

SSIS Setup

What is new in SSIS 2016

Key components of a modern ETL solution

Data warehouse loading techniques

Dealing with Data Quality

SSIS performance and scalability

Unleash the power of SSIS script task and component

SSIS and advanced analytics

On-premises and Azure Big Data integration

Extending SSIS custom tasks and transformations

Scale Out with SSIS 2017

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required