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:

Explanation:

Show Hint

Leave a Reply 3

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

Milen

Milen

Server name

Reply

Henry Figgins

Henry Figgins

“one database. An Environment variable contains the name of the database.”
People that have passed 461 would know that a server can contain more than one catalog (aka database) and if the variable contains the only database it can connect to, the connectoin string must parameterize the initial catalog

Reply