THE SQL Server Blog Spot on the Web

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

Andy Leonard

Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, developer of the Data Integration Lifecycle Management (DILM) Suite, a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and the Stairway to Integration Services.

Three Free Webinars About Using the SSIS Catalog

Mr. Kent Bradshaw and Llian the Wonder PuppyKent Bradshaw and I are delivering a series of webinars 27-29 Dec 2016 called SSIS Academy: Using the SSIS Catalog.

Why? We’ve been using the SSIS Catalog in Production since 2012. We’ve learned a lot about how it works. Some parts of the SSIS Catalog are complex and we want to share – as best we can – what we’ve learned.

The daily agenda is:

Day 1: SSIS Catalog Introduction and Deployment – We discuss and demo creating an SSIS Catalog and deploying SSIS Projects to the SSIS Catalog.
Day 2: SSIS Execution and Monitoring – We cover executing SSIS packages using the Catalog, and monitoring execution reports. We will also demo alternatives to Catalog-based package execution.
Day 3: SSIS Configuration – No matter which method or tool you select to manage externalization, configuration is complex. In this session, Kent and I discuss and demo SSIS Catalog Environments, References, and Reference Mappings to project and package parameters.

Our intention is to remain “in the box:” We plan to only demonstrate and discuss how to use the SSIS Catalog as it ships. The purpose of this series is to help data integration professionals learn more about applying the SSIS Catalog to enterprise data integration.

Sound interesting? Register today!

:{>

Learn More:
Data Integration Lifecycle Management (DILM) Suite – (mostly) free – some not-free – software to help you manage SSIS in the enterprise.
Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
Coming Soon: A Command-Line Interface for Managing SSIS Catalogs
Stairway to Integration Services

Related Training:
SSIS Lifecycle Management (free recording, registration required)
IESSIS1: Immersion Event on Learning SQL Server Integration Services – April 2017, Chicago
IESSIS2: Immersion Event on Advanced Integration Services – May 2017, Chicago

Need help implementing an SSIS solution?
Contact Enterprise Data & Analytics today!

Published Thursday, December 22, 2016 1:00 PM by andyleonard

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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

News


My Companies



Community Awards

Friend of Red Gate

Contact Me

Archives

Privacy Statement