Deploying SQL Server 2008 Integration Services Packages
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.
This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview of the package deployment options available, the preparations of packages for deployment using package configurations, and the creation of a deployment utility. It also covers the methods used to install packages once deployed to the server, including the use of the Package Installation Wizard. The course also discusses the methods for running packages from within BIDS and using the DTExec command utility, and outlines how to schedule package execution using SQL Server Agent jobs. Also discussed are the methods and tools available to monitor and secure Integration Services and SSIS packages. This includes 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.
Deploying and Executing SSIS Packages
- recognize how to create a package configuration
- deploy SSIS packages
- manually execute SSIS packages
- schedule the execution of your SSIS packages
- use the SQL Server Import and Export Wizard to create a simple package
- set up the Deployment Bundle
- install and run SSIS packages