tailieunhanh - Hands-On Microsoft SQL Server 2008 Integration Services part 31

Hands-On Microsoft SQL Server 2008 Integration Services part 31. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 278 Hands-On Microsoft SQL Server 2008 Integration Services Figure 7-2 A password is required to open packages saved with the EncryptSensitiveWithPassword option. 25. You will see an error message saying that there were errors while loading the package which prompts you to see the Error List for more details. Click OK to proceed further. 26. The package will be loaded. Open the Error List window and you will see an error explaining that the package will be loaded without the encrypted information Error loading Downloading zipped Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. Press F5 to run the package which will fail specifying that the password was not allowed in the Execution Results pane. Click Stop Debugging. 27. In the Connection Managers area double-click the FTP Connection Manager and specify the password in the credentials area. Click OK to close this window. Press F5 to run the package. The package won t run instead it returns an error similar to the one shown in Figure 7-3. Close the error notifications. You get this error because you are still using the EncryptSensitiveWithPassword protection level and haven t provided a package Figure 7-3 Error returned on saving a package without specifying a package password Chapter 7 Securing Integration Services Packages 279 password to encrypt the sensitive information. Until you supply the package password you can t save the package and subsequently can t execute it. Click Stop Debugging. 28. At this time you can supply a new package password to save the package and as you ve already provided the sensitive information that is the FTP server password you should be able to save and execute the package. Type yY56789zZ in the PackagePassword field and press F5 to run the package. The package executes successfully this time. Exercise Encrypting All Information in the Package Using a User