Exam Essentials
Understand how to design security for accessing packages. You should have a good understanding of how the various security options for packages affect the ability of other users to change and run packages you create. Relying on SQL Server for storage and security offers a nice alternative to the package-level security options.
Understand how to deploy, move, and schedule packages. Packages are deployed using DTExec.exe or DTExecUI.exe after you have created a manifest file (which is an XML document). Remember that the manifest is not created by default; you have to enable the CreateDeploymentUtility property of the package. You can move packages using the Export Wizard or using DTUtil.exe at the command line. Packages can be scheduled ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
