Course Details

Previous Page


Managing SSIS Packages in SQL Server 2008


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
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

Prerequisites
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 (hours)
1.5

Lesson Objectives

Managing SSIS Packages in SQL Server 2008

  • recognize how to store information in a log file
  • recognize how to create a log on a server
  • configure a package to handle bad data
  • recognize how to perform debugging
  • recognize ways to secure SSIS packages
  • implement logging
  • debug SSIS packages
  • secure an SSIS package
  • Course Number:
    md_mqbm_a10_it_enus