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 *