When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

pluralsight logo

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.

     
  • 5
  •  |
  • Reviews ( 23 )
Free

This Course Includes

  • iconpluralsight
  • icon5 (23 reviews )
  • icon2 hour 18 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcore courses
  • iconpluralsight

About Managing SSIS Projects

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.

What You Will Learn?

  • 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.