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:
✑ The deployment model must support changing the content of connection strings by using parameters at execution time.
✑ The deployment model must automatically log events to the SSISDB database.
✑ Maximize performance at execution time.
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 project deployment model. Modify connection manager properties to use project parameters.
B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
C. Use a package 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.
D. Use a project deployment model. Modify connection manager properties to use package parameters.
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that incl
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that incl
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!