tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P80

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P80: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | ETL Techniques Chapter 8 377 Table Continued. SSIS Package Deployment Tools Tool DTUtil Description DTUtil is a command-line utility that can be used to perform imports and exports of packages from the SSIS package storage on the server in addition to a number of other package management tasks. Securing SSIS Packages Once a package is deployed you can control who has the ability to run it and change it. For packages saved to the file system you can simply use NTFS permissions to control security. For packages saved to SQL Server though you have a role-based security model. Regardless of how access to the packages is handled however the sensitive information needed in a package like credentials for databases is never stored in clear text. This information is either not stored or it is encrypted. Using Package Protection Levels When you save a package you can choose from a number of protection level options. These protection levels specify how much data is encrypted if any and how it is encrypted. You can decide how much of a package to encrypt and how to encrypt it when saving a package. You could not encrypt anything encrypt just the sensitive data like passwords or specific variable values or encrypt the entire package. When you encrypt data you can choose between a key that can be used by only yourself or a password that you can share with others. You also can let the server encrypt the package if you are saving it to SQL Server. Table lists the available package encryption options. 378 Chapter 8 ETL Techniques Table Package Encryption Options Protection Level Description Do not save sensitive data Any content in the package that is sensitive like clear text credentials will not be saved in the package. Any users who want to work with the package will have to provide that information themselves. Encrypt sensitive with password Sensitive data is encrypted using the supplied password. You can share that password with others to allow them to open the .