Which property should you use?

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012
database.
The package is allowed to connect to only one database. An Environment variable contains the name of
the database.
The OLE DB project connection manager has been parameterized.
You need to configure the connection manager property to accept the value of the Environment
variable.
Which property 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 package is allowed to connect to only one database. An Environment variable contains the name of
the database.
The OLE DB project connection manager has been parameterized.
You need to configure the connection manager property to accept the value of the Environment
variable.
Which property 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 *