Don’t miss it—Apress Access is only $99 for the holiday season! Subscribe now >>

Data Integration Life Cycle Management with SSIS

A Short Introduction by Example

Authors: Leonard, Andy

  • Practices in this book enable repeatable automation, which is at the heart of DevOps practices in the modern enterprise
  • Shows you how to more effectively manage the data integration lifecycle, which is the majority task in most data science projects
  • Covers SQL Server Integration Services, which is a powerful enterprise data integration engine
see more benefits

Buy this book

eBook $19.99
price for USA (gross)
  • ISBN 978-1-4842-3276-7
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $24.99
price for USA
  • ISBN 978-1-4842-3275-0
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history.
Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. 
What You'll Learn

  • Generate dozens of SSIS packages in minutes to speed your integration projects
  • Reduce the execution of related groups of SSIS packages to a single command
  • Successfully handle SSIS catalog deployments and their projects 
  • Monitor the execution and history of SSIS catalog projects
  • Manage your enterprise data integration life cycle through automated tools and utilities
Who This Book Is For

Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS.

About the authors

Andy Leonard is Data Philosopher at Enterprise Data & Analytics, and SSIS trainer, consultant, and developer. He also is a Business Intelligence Markup Language (Biml) developer and BimlHero. Andy also is an SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The BIML Book (Apress), and SQL Server Integration Services Design Patterns (Apress).

Reviews

   
  

Table of contents (13 chapters)

Buy this book

eBook $19.99
price for USA (gross)
  • ISBN 978-1-4842-3276-7
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $24.99
price for USA
  • ISBN 978-1-4842-3275-0
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Data Integration Life Cycle Management with SSIS
Book Subtitle
A Short Introduction by Example
Authors
Copyright
2018
Publisher
Apress
Copyright Holder
Andy Leonard
eBook ISBN
978-1-4842-3276-7
DOI
10.1007/978-1-4842-3276-7
Softcover ISBN
978-1-4842-3275-0
Edition Number
1
Number of Pages
XIII, 185
Number of Illustrations
6 b/w illustrations, 173 illustrations in colour
Topics