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
More courses by Chris Behrens
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Chris. Be barons and welcome to my course configuring and deploying S S s packages. Once you've got some work with S s, I s under your belt and your data is moving back and forth between your sources and your production databases. You naturally turn your attention to 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 SSH! I is packages the right and the wrong ways to deploy and execute a society is 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 your SS. I is 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 Docker is. 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 I is packages course at Pluralsight.