You are developing a SQL Server 2008 Integration Services (SSIS) package for Company.com.
There is a development server called TestSQL in your package.
For the development server and the production server, you could not move the information between them.
When you publish the package to the TestSQL server.
You get the error message below:The package could not link to the TestSQL server.
You should make sure that you could alter the package to refer to the TestSQL server when being implemented.
Which is the correct answer?
A.
You should change the attributes of the package to utilize the DontSaveSensitive package protection level.
B.
Before altering the connection string by hand you should change the deployment manifest file in Microsoft Notepad.
C.
You should choose the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then alter the connection string.
D.
You change the attribute of the package to utilize store procedure.
Explanation:
Creating Package Connection Managers
A package connection manager, sometimes simply called a package connection, is independent of project data sources. However, package connections can reference a project data source. A package connection lets the different components in SSIS communicate with an object (such as a database, file, or server) outside the package. You can use package connections as source adapters, FTP or e-mail servers, or flat files.