Microsoft
70-448 · Question #14
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. You deploy the package to the file system in the…
The correct answer is C. EncryptAllWithPassword. See the full explanation below for the reasoning.
Question
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. You deploy the package to the file system in the production environment. The users report that the connection strings contained in the package are blank. The package fails to execute. You need to change the protection level of the package to ensure that users can view and execute the package. Which protection level should you use?
Options
- ADontSaveSensitive
- BEncryptAllWithUserKey
- CEncryptAllWithPassword
- DServerStorage
How the community answered
(30 responses)- A7% (2)
- B17% (5)
- C73% (22)
- D3% (1)
Community Discussion
No community discussion yet for this question.