Managing SSIS Packages in SQL Server 2008

This course is included in our On-demand training solution.


This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience

IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer


Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration

90 min.

Course Objectives

Implementing SSIS Package Logging

  • recognize how to store information in a log file
  • recognize how to create a log on a server
  • Debugging and Error Handling in SSIS Packages

  • configure a package to handle bad data
  • recognize how to perform debugging
  • Securing SQL Server 2008 SSIS Packages

  • recognize ways to secure SSIS packages
  • Monitoring and Securing SSIS Packages