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.