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
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
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 s s I s projects. I am the owner of Arcane Training and Consulting, a book author and content creator for Pearl site. In this course, you will learn the tools and techniques for properly managing s A science projects. This includes creating and managing society catalogues 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 package parts to speed as a science development, you also learn how logging works and how to execute packages in parallel to speed package run times. Some of the major topics that we will cover include creating the S S I s catalogue blogging both built in and custom configuring a project and creating as societies templates. By the end of this course, you understand how to effectively manage your own as a science projects. Before beginning this course, you should be familiar with sequel server integration services as well as sequel server databases. Help You'll join me on this journey to learn how to manage your s a science projects with the course managing s I s projects at Pearl site