Managing SSIS Projects

This course will teach you how to grow from SSIS project development to management. You'll also learn managing the SSIS catalog, deployments, using environments, and seeing how to speed up your project development time with templates.
Course info
Rating
(14)
Level
Intermediate
Updated
May 4, 2020
Duration
2h 18m
Table of contents
Course Overview
Introduction
Creating and Managing the Catalog
Deploying to the Catalog
Using Canned Dashboard Reports
Implementing Parallelism for Faster Loading in SSIS
Configuring a Project or Package
Managing Variables and Connection Strings through Environments
Using the Catalog for Logging
Developing Custom Logging
Creating an SSIS Package Template for Re-use
Creating Reusable Units of an SSIS Package Workflow
Summary
Description
Course info
Rating
(14)
Level
Intermediate
Updated
May 4, 2020
Duration
2h 18m
Description

Managing SSIS Projects can be a labor intensive task for the beginner. In this course, Managing SSIS Projects, you will gain the ability to effectively manage your SSIS projects. First, you will learn how to create and manage your SSIS Catalog. Next, you will discover how logging works in SSIS, as well as learn the array of reports based on the logs. Finally, you will explore how to use templates to speed package development. When you're finished with this course, you will have the skills and knowledge of managing SSIS projects needed to be both an effective SSIS developer and administrator.

About the author
About the author

Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.

More from the author
More courses by Robert Cain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Robert Cain, and welcome to my course managing. SSH! I is projects. I am the owner of Arcane Training and Consulting, a book author and content creator for Pluralsight. In this course, you will learn the tools and techniques for properly managing SEC is projects this includes creating and managing a society is catalogs as well as deploying projects to it. You'll also learn how to use package environments to manage project needs. In addition, you will learn techniques such as package templates and packaged parts to speed as a CSS development. You'll also learn how logging works and how to execute and parallel to speed package runtime. Some of the major topics that we will cover include creating the SEC is catalog blogging both built in and custom configuring a project, and creating SEC is templates. By the end of this course, you'll understand how to effectively manage your own SEC is projects before beginning this course, you should be familiar with SQL Server integration services as well as SQL Server database is, I hope you'll join me on this journey to learn how to manage your SEC is projects with the course. Managing SEC is projects at Pluralsight