Chapter 10. Securing and Deploying SSIS Packages

After completing this chapter, you will be able to:

  • Understand the components of package security and learn to automate package deployment to a server.

  • Understand package deployment options: the package deployment utility, command-line options, and package importing and exporting.

  • Use role-based security to protect deployed packages for execution and administration.

  • Learn to monitor package execution and configure and view SSIS event logs.

Up to this point, you’ve designed packages in Business Intelligence Development Studio (BIDS) and transformed, imported, and exported small amounts of test data in the development environment. The package designer and development platform does a good job of emulating ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.