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?
A.
Configure the package to use the DontSaveSensitive package protection level.
B.
Configure the package to use the EncryptSensitiveWithPassword package protection
level.
C.
Configure the package to use the EncryptAllWithUserKey package protection level.
D.
Remove the user name and the password from the connection string before you deploy
the package.