Skip to main content
  • Book
  • © 2018

Data Integration Life Cycle Management with SSIS

A Short Introduction by Example

Apress

Authors:

  • 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

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xiii
  2. Introduction to DILM

    • Andy Leonard
    Pages 1-5
  3. SSIS

    • Andy Leonard
    Pages 7-24
  4. Source Control

    • Andy Leonard
    Pages 25-39
  5. Deploy to the SSIS Catalog

    • Andy Leonard
    Pages 41-59
  6. Configure the SSIS Catalog Project

    • Andy Leonard
    Pages 61-82
  7. Catalog Browser

    • Andy Leonard
    Pages 83-94
  8. SSIS Catalog Compare

    • Andy Leonard
    Pages 95-122
  9. SSIS Framework Community Edition

    • Andy Leonard
    Pages 123-129
  10. Catalog Reports

    • Andy Leonard
    Pages 131-135
  11. BimlExpress Metadata Framework

    • Andy Leonard
    Pages 137-175
  12. Conclusion

    • Andy Leonard
    Pages 177-177
  13. Links

    • Andy Leonard
    Pages 179-180
  14. Erratum to: Introduction to DILM

    • Andy Leonard
    Pages E1-E1
  15. Back Matter

    Pages 181-185

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 ofrelated 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.

Authors and Affiliations

  • Farmville, USA

    Andy Leonard

About the author

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).

Bibliographic Information

  • Book Title: Data Integration Life Cycle Management with SSIS

  • Book Subtitle: A Short Introduction by Example

  • Authors: Andy Leonard

  • DOI: https://doi.org/10.1007/978-1-4842-3276-7

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)

  • Copyright Information: Andy Leonard 2018

  • Softcover ISBN: 978-1-4842-3275-0Published: 27 November 2017

  • eBook ISBN: 978-1-4842-3276-7Published: 17 November 2017

  • Edition Number: 1

  • Number of Pages: XIII, 185

  • Number of Illustrations: 6 b/w illustrations, 173 illustrations in colour

  • Topics: Database Management, Microsoft and .NET

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access