Master the SSIS Catalog – 2020 Q3

$995.00

Join Microsoft Data Platform MVP, author, speaker, and blogger Andy Leonard for the next delivery 16 September 2020 and master the SSIS Catalog in this live, full-day training course!

Description

The SQL Server Integration Services (SSIS) Catalog is an SSIS Framework built into SSIS and administered using SQL Server Management Studio (SSMS).
In this half-day course, Microsoft Data Platform MVP and author Andy Leonard walks you through creating, configuring, and executing SSIS using the SSIS Catalog

About Master the SSIS Catalog

Data integration is the foundation of data science, machine learning, artificial intelligence, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals and DBAs responsible for deploying, configuring, and managing data integration at enterprise-scale who want to learn more about the SSIS Catalog.

You will learn:
– Creating an SSIS Catalog
– Deploying SSIS projects to the SSIS Catalog
– SSIS Catalog Execution options
– Configuring connection strings and parameter values.
– Azure Data Factory and the SSIS Catalog

Agenda

1. A Brief History of SSIS Deployment Models
2. Deploying SSIS projects
3. SSIS execution options
4. Configuring parameters and connection managers
5. The SSIS Catalog in the Cloud

Interested in more SSIS, Biml, and Azure Data Factory training from Andy Leonard?

Visit Andy’s SSIS Training page!
Master the Fundamentals of Azure Data Factory
Expert SSIS
From Zero to SSIS
Advanced SSIS

About Andy

Andy Leonard is a Microsoft Data Platform MVP, Author, Data Philosopher and BimlHero from Farmville, Virginia specializing in data integration with SSIS, SSIS performance tuning, and automation. He is very passionate about technology but has interests in literature, mathematics, farming, and engineering.

This is a live online class. The class is hosted at GoToWebinar, live with Andy Leonard on webcam. We will take 15-minute breaks each hour and a 90-minute lunch break. Audio is available via your computer audio or dialing into a US phone number – we recommend using a headset.