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 Summary 1m Package vs. Project Models 5m Demo: XML Configuration 5m Introduction 3m The Other Methods of Package Configuration 5m Demo: Command Line Configuration 1m Demo: Our Simple Package 4m
Deploying and Executing SSIS Packages in a CICD Pipeline
Demo: Variables and Expressions in Integration Services 5m A Security Problem with This Build 3m Making This Work in a Build Pipeline 2m Package CICD Wrap-up 3m Demo: Getting the Password Out of the Package 3m Understanding Synchrony 5m Demo: Executing Your Package in a Jenkins Pipeline 3m
Identifying and Fixing Performance and Logic Issues
Summary 1m Logging and Instrumentation with SSIS 3m The Worst Thing You Can Do 1m Demo: Logging and Instrumentation with SSIS 4m Half-splitting 3m An Anti-Pattern for Integration Services Performance 2m Demo: Fixing the Big Table Anti-Pattern 3m Exceptions Don’t Belong in SSIS 1m Introduction 1m
Testing and Verifying an SSIS Package
Demo: An Automated Test Build 3m A Testing and Verification Architecture 3m Summary 1m DEMO: Asserting the Results of a Package 3m Going Deeper with This Pattern 1m What We Mean by “Testing” 3m Demo: SQL Server in Docker 4m Where Our Target DB Is Running 1m
Understanding Security in ETL Deployments
A Problematic Deployment Pattern 7m Security Considerations for Data at Rest 6m Summary 1m Security Considerations for Transferring Files 9m A Final Word About Deployment Security 1m A Different Section 1m
The Future of Integration Services
Introduction 1m Azure Data Factory Options 1m Demo: Local to Azure DB 3m Course Wrap-up 2m
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
Using Intermediate Wireshark Features
Intermediate
2h 1m
Jun 25, 2020
Working with Colors and Images in CSS
Beginner
1h 38m
May 7, 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