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:



Leave a Reply 0

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