Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 15: Securing and Scheduling SSIS Packages
Chapter 15: Securing and Scheduling SSIS Packages
| 1. | To encrypt all the content of the packages, you need to use the DTUtil utility with the / encrypt command-line parameter, running the utility from the directory of the packages. Each DTUtil statement will look like the following:
dtutil.exe /file MyPackage.dtsx /encrypt file;MyPackage.dtsx;3;EncPswd In addition, because all the packages contain a shared connection username and password, you can use SSMS to deny access to the configuration table to all accounts other than the SQL Server Agent service account or the SQL Server Agent Proxy account that will be executing the package. |
| 2. | To schedule the packages to be run, create a SQL Server Agent job and several job steps to execute the packages. When you identify the package, you will need to enter the password that you specified in the DTUtil command-line statement in Step 1 to encrypt the packages (EncPswd). The job could also be run by using a proxy account. That account would need to have the proper security credentials to access the SQL Server configuration table so that the connection username and password are updated at execution time. |
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint