70-448 · Question #2
You develop a package by using SQL Server 2008 Integration Services (SSIS). You use a local instance of SSIS to develop and test the package. The package uses an XML configuration file that contains…
The correct answer is B. Configure the package to use the EncryptSensitiveWithPassword package protection level. See the full explanation below for the reasoning.
Question
You develop a package by using SQL Server 2008 Integration Services (SSIS). You use a local instance of SSIS to develop and test the package. The package uses an XML configuration file that contains a connection string. The connection string includes a user name and a password to connect to the source data. You deploy the package to the production server. You discover that validation errors occur when the package is being executed. You need to ensure that the package executes successfully in the production environment. What should you do?
Options
- AConfigure the package to use the DontSaveSensitive package protection level.
- BConfigure the package to use the EncryptSensitiveWithPassword package protection level.
- CConfigure the package to use the EncryptAllWithUserKey package protection level.
- DRemove the user name and the password from the connection string before you deploy the package.
How the community answered
(30 responses)- A3% (1)
- B80% (24)
- C7% (2)
- D10% (3)
Community Discussion
No community discussion yet for this question.