Configuring and Deploying SSIS Packages

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.
Course info
Level
Advanced
Updated
Jun 3, 2020
Duration
2h 1m
Table of contents
Course Overview
Understanding the Basics of SSIS Configuration
Deploying and Executing SSIS Packages in a CICD Pipeline
Identifying and Fixing Performance and Logic Issues
Testing and Verifying an SSIS Package
Understanding Security in ETL Deployments
The Future of Integration Services
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
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