Microsoft
70-448 · Question #295
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…
The correct answer is C. On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box. See the full explanation below for the reasoning.
Question
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?
Options
- AModify the properties of the package to use the DontSaveSensitive package protection level.
- BModify the deployment manifest file in Microsoft Notepad, and then modify the connection string manually.
- COn the Connection Managers tab of the Execute Package utility, select the Connection Manager check box,
- DModify the properties of the package to use the ServerStorage package protection level.
How the community answered
(40 responses)- A8% (3)
- B15% (6)
- C75% (30)
- D3% (1)
Community Discussion
No community discussion yet for this question.