Hands-On Microsoft SQL Server™ 2005 Integration Services

Chapter 7. Securing Integration Services Packages

In This Chapter

Digitally Signing the Package Excluding Sensitive Information from the Package Encrypting Sensitive Information in the Package Encrypting All the Information in the Package Using Integration Services Fixed Database Level Roles Protecting Packages and Metadata at the Storage Level Summary

Security in SQL Server 2005 and that of Integration Services has been enhanced a great deal more compared to DTS 2000. DTS uses package password protection, SQL Server Security, and SQL Server Agent service security, while Integration Services provides the features used by DTS and a lot more to enhance data security. SSIS provides the ability to secure data and connections from various perspectives ...