Hands-On Microsoft SQL Server™ 2005 Integration Services

Summary

Security is the most often discussed topic these days in the IT industry. As a DBA or information analyst, you need to make sure that the contents of SSIS packages are secure. You have seen that the Integration Services provides a facility to sign a package to check for its integrity and provides six package protection levels out of which four are for encrypting packages, one is for excluding sensitive information, and one is for using database level roles. You have learned how to exclude sensitive information in your packages and encrypt sensitive information in packages using a user key or password. You have also used database level roles to protect the package with read or write access controls. You should understand the various considerations ...