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.
Author Name: Robert Cain
Author Description:
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, teleco… more

Table of Contents

• Course Overview
  1min
• Introduction
  8mins
• Creating and Managing the Catalog
  7mins
• Deploying to the Catalog
  9mins
• Using Canned Dashboard Reports
  13mins
• Implementing Parallelism for Faster Loading in SSIS
  11mins
• Configuring a Project or Package
  6mins
• Managing Variables and Connection Strings through Environments
  11mins
• Using the Catalog for Logging
  27mins
• Developing Custom Logging
  15mins
• Creating an SSIS Package Template for Re-use
  11mins
• Creating Reusable Units of an SSIS Package Workflow
  9mins
• Summary
  2mins