You need to design a solution that meets the requirements

You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
Ensure that the deployment model supports changing the content of connection strings by
using parameters at execution time.
Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
Maximize performance at execution time.
Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
Ensure that the deployment model supports changing the content of connection strings by
using parameters at execution time.
Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
Maximize performance at execution time.
Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A.
Use a package deployment model. Use a SQL Server package configuration with a
common filter. Change the contents of the SSIS Configurations table at runtime.

B.
Use a project deployment model. Configure connections in an XML configuration file
referenced by an environment variable that corresponds to the SQL Server environment of
each SSIS package.

C.
Use a package deployment model. Save each SSIS package to a file share that can be
accessed from all environments.

D.
Use a project deployment model. Modify connection manager properties to use project
parameters. Ensure that the SSISDB database is created.

Explanation:



Leave a Reply 1

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