You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. To meet the business development, you use SQL Server 2008
to create a SQL Server 2008 Integration Services (SSIS) package. You have a Research
server named SQL_RES01 and a Sales server named SQL_SAL01. SQL_RES01 is not
connected to SQL_SAL01 in the network. Then you have the SSIS package configured on
the SQL_SAL01 server, however, you get a failure of the configuration, which is because the
SQL_RES01 server can not be connected by the package. In order to solve that problem,
the package should be modified to refer to the SQL_SAL01 server when you execute the
configuration.
Which solution would be chosen to solve that problem?
A.
After selecting the Connection Manager check box, you should modify the connection
string on the
Connection Managers tab of the Execute Package utility
B.
Use the ServerStorage package protection level to modify the properties of the package.
C.
After modifying the deployment manifest file in Microsoft Notepad, you should modify the
properties of the package
D.
Use the DontSaveSensitive package protection level to modify the properties of the
package.
E.
After modifying the deployment manifest file in Microsoft Notepad, you should modify the
connection string manually.