Which property and parameter should you use?

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into a
SQL Server 2012 database.
The name of the target instance is passed to the package via an Environment variable.
The Environment variable provides the server name to the Project parameter named
ServerName.
The OLE DB Project Connection Manager has been parameterized.
You need to configure the Connection Manager property to accept the parameter.
Which property and parameter should you use? (To answer, configure the appropriate option
or options in the dialog box in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into a
SQL Server 2012 database.
The name of the target instance is passed to the package via an Environment variable.
The Environment variable provides the server name to the Project parameter named
ServerName.
The OLE DB Project Connection Manager has been parameterized.
You need to configure the Connection Manager property to accept the parameter.
Which property and parameter should you use? (To answer, configure the appropriate option
or options in the dialog box in the answer area.)

Answer:

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *