Loading...
Skip to content
AndyLeonard.blog() AndyLeonard.blog()
  • RSS
  • Twitter
  • LinkedIn
  • About Andy
  • SSIS and ADF Training
  • Mailing List
  • linktr.ee

Data Integration Life Cycle Management with SSIS: A Short Introduction by Example is Available for Pre-Order!

Posted on October 11, 2017Updated on December 13, 2017by Andy LeonardCategories:Biml, Biml Frameworks, BimlExpress Metadata Framework, Books, Catalog Reports, DILM, DILM Suite, Framework Browser, SSIS Catalog Browser, SSIS Catalog Compare, SSIS Frameworks

I’m excited to announce that book #3 for 2017 is available for pre-order at Amazon! Data Integration Life Cycle Management with SSIS: A Short Introduction by Example is a(nother) short-ish book (~112 pages) that offers insight into managing SQL Server Integration Services (SSIS) in an enterprise.

I wrote the book to demonstrate managing SSIS as it ships (out of the box) and the first half of the book covers some thoughts on source control, deployment, and configuration in the SSIS Catalog. It’s not exhaustive, but presents some options. I identify a few gaps and share some solutions I and others have thought of.

The second half of the book demonstrates some thoughts I have on closing said gaps and automating data integration with SSIS using Business Intelligence Markup Language (Biml) from Varigence. I built a collection of tools and utilities that I call the Data integration Lifecycle Management Suite. The tools include:

  • Catalog Reports
  • Catalog Browser
  • SSIS Framework Community Edition
  • Framework Browser
  • SSIS Catalog Compare
  • CatCompare
  • BimlExpress Metadata Framework

I sell SSIS Catalog Compare and CatCompare at DILM Suite;  Catalog Browser and Framework Browser are free; Catalog Reports and SSIS Framework Community Edition are free and open source.

At the time of this writing I am working on an update to the Catalog Compare bundle which include SSIS Catalog Compare – and Graphical User Interface (or GUI) – and CatCompare – a Command-Line Interface (or CLI). I hope to release the next versions before the end of 2017.

:{>

Learn more:

Expert SSIS Training (Live, 2 Days) – 4-5 Dec 2017
SQLSkills Immersion Event IESSIS1: SSIS Training – 7-11 May 2018 in Chicago
Contact Enterprise Data & Analytics for private SSIS and Biml training anytime, anywhere!

 

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>

TaggedData Integration Lifecycle ManagementDILMDILM BookDILM SuiteSSISSSIS Catalog Compare

Training


Learn Azure Data Factory (from me!) 5 Dec 2023! Register today for Master the Fundamentals of Azure Data Factory.

Do you need to level-up your ADF and SSIS skills in a hurry? Sign up for the Premium Level – All Recordings for 1 Year and get started on a full year of ADF and SSIS training!

I still deliver consulting! Want to migrate enterprise SSIS to the cloud? Need help with that data warehouse project? SSIS running too slow? Contact me. At Enterprise Data & Analytics, we are here to help!

  • RSS
  • Twitter
  • LinkedIn
© 2023 by AndyLeonard.blog(). All rights reserved.
Back to top