Configuring and Deploying SSIS Packages

By Chris Behrens
Getting data out of one data source and into another is a key challenge for business intelligence. This course will teach you how Integration Services gets configured and deployed in the real world and prepare you for managing workflows with SSIS.
Play course overview
Course info
Level
Advanced
Updated
Jun 3, 2020
Duration
2h 1m
Table of contents
Course Overview
Course Overview 1m
Understanding the Basics of SSIS Configuration
Configuring Your IS Package 4m Demo: Command Line Configuration 1m Demo: Our Simple Package 4m Demo: XML Configuration 5m Introduction 3m Package vs. Project Models 5m Summary 1m The Other Methods of Package Configuration 5m
Deploying and Executing SSIS Packages in a CICD Pipeline
Demo: Variables and Expressions in Integration Services 5m A Security Problem with This Build 3m Demo: Executing Your Package in a Jenkins Pipeline 3m Demo: Getting the Password Out of the Package 3m Making This Work in a Build Pipeline 2m Package CICD Wrap-up 3m Understanding Synchrony 5m
Identifying and Fixing Performance and Logic Issues
An Anti-Pattern for Integration Services Performance 2m Demo: Fixing the Big Table Anti-Pattern 3m Demo: Logging and Instrumentation with SSIS 4m Exceptions Don’t Belong in SSIS 1m Half-splitting 3m Introduction 1m Logging and Instrumentation with SSIS 3m Summary 1m The Worst Thing You Can Do 1m
Testing and Verifying an SSIS Package
A Testing and Verification Architecture 3m DEMO: Asserting the Results of a Package 3m Demo: An Automated Test Build 3m Demo: SQL Server in Docker 4m Going Deeper with This Pattern 1m Summary 1m What We Mean by “Testing” 3m Where Our Target DB Is Running 1m
Understanding Security in ETL Deployments
A Different Section 1m A Final Word About Deployment Security 1m A Problematic Deployment Pattern 7m Security Considerations for Data at Rest 6m Security Considerations for Transferring Files 9m Summary 1m
The Future of Integration Services
Azure Data Factory Options 1m Course Wrap-up 2m Demo: Local to Azure DB 3m Introduction 1m
Description
Course info
Level
Advanced
Updated
Jun 3, 2020
Duration
2h 1m
Description

Getting data from a customer or vendor, out of their file, and into your datastore is a key challenge for modern data-driven enterprises. In this course, Configuring and Deploying SSIS Packages, you’ll learn to drive environment-specific SSIS content and get it delivering value. First, you’ll explore the different ways to configure SSIS packages. Next, you’ll discover how to deliver and deploy with a CICD pipeline. Finally, you’ll learn how to monitor and troubleshoot your packages. When you’re finished with this course, you’ll have the skills and knowledge of Integration Services needed to make your package do the business intelligence work of your enterprise.

About the author
Chris Behrens
About the author

Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face.

More from the author
Running Jenkins in Docker
Intermediate
2h 6m
Jul 13, 2020
Using Intermediate Wireshark Features
Intermediate
2h 1m
Jun 25, 2020
More courses by Chris Behrens
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is crisp, Be barons and welcome to my course configuring and deploying SS s packages. Once you've got some work with s s s under your belt and your data is moving back and forth between your sources and your production databases, you naturally turn your attention toe automating this process. This leads two big questions of driving how your packages are configured and deployed. And what exactly do we mean when we say deployment in a package context? Some of the major topics that we will cover include the different ways to configure S a size packages the right in the wrong ways to deploy and execute the society's packages. Automating all of this with Bill verifying changes to a package and how to do all of this securely. By the end of this course, you will have the skills and knowledge of how to configure and execute us society's packages automatically and effectively before beginning this course, you should be familiar with integration. Services have a decent grasp of what a software bill does and understand what Dockery's. I hope you'll join me on this journey to learn how to make your packages work with different configurations and different environments in the configuring and deploying SS size packages. Course that plural side

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT