You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server
2008.
You use a development server named SQL_DEV1. There is no network connectivity
between the development server and the production server.
You deploy the package to the SQL_PROD1 server.
The package fails to execute. The error message states that the package cannot connect to
the SQL_DEV1 server.
You need to modify the package to refer to the SQL_PROD1 server when being executed.
What should you do?
A.
Modify the properties of the package to use the DontSaveSensitive package protection
level.
B.
Modify the deployment manifest file in Microsoft Notepad, and then modify the connection
string manually.
C.
On the Connection Managers tab of the Execute Package utility, select the Connection
Manager check box, and then modify the connection string.
D.
Modify the properties of the package to use the ServerStorage package protection level.