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