Managing SSIS Projects

Focused View

Robert Cain

2:18:27

41 View

01. Course Overview

01. Course Overview.mp4

01:32

02. Introduction

01. Introducing the Course.mp4

04:38

02. Understanding the Demo Project.mp4

04:11

03. Creating and Managing the Catalog

01. Creating and Managing the Catalog.mp4

07:41

04. Deploying to the Catalog

01. Deploying to the Catalog.mp4

06:03

02. Executing Packages from the Catalog.mp4

03:49

05. Using Canned Dashboard Reports

01. Executing the Reports and Understanding the Overview Report.mp4

06:22

02. Reviewing the Messages and Performance Reports.mp4

03:26

03. Running the Server Level Reports.mp4

03:40

06. Implementing Parallelism for Faster Loading in SSIS

01. Understanding the Master Package and Controlling Package Flow.mp4

06:48

02. Reviewing the Required Control Flow Components.mp4

05:09

07. Configuring a Project or Package

01. Configuring a Project or Package.mp4

06:51

08. Managing Variables and Connection Strings through Environments

01. Setting up and Mapping Packages to Environments.mp4

06:06

02. Running Packages Using Environments.mp4

05:47

09. Using the Catalog for Logging

01. Understanding the Basic Logging Level.mp4

03:24

02. Examining Performance and Verbose Level Logging.mp4

03:32

03. Learning About Runtime Lineage and Other Logging Levels.mp4

02:56

04. An Overview of the Catalog Views.mp4

03:12

05. Sample Queries. List All Packages.mp4

02:57

06. Sample Queries. Get Package Executions, Runtimes.mp4

03:28

07. Sample Queries. Top 5 Runtimes, Listing Executables, Last 5 Executions.mp4

03:28

08. Sample Queries. Log Messages, Executive Dashboard.mp4

04:13

10. Developing Custom Logging

01. Understanding the Logging Table.mp4

02:41

02. Control Flow Tasks for Custom Logging.mp4

07:39

03. Querying the Logging Data with Custom Views.mp4

05:35

11. Creating an SSIS Package Template for Re-use

01. Creating a Template Package.mp4

03:18

02. Deploying the Template.mp4

04:02

03. Creating a Package from a Template.mp4

04:32

12. Creating Reusable Units of an SSIS Package Workflow

01. Creating and Using a Package Part.mp4

05:20

02. Advanced Package Parts.mp4

03:59

13. Summary

01. Summary.mp4

02:08

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Project Management

Robert Cain

Instructor's Courses

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications, and nuclear power.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.