Microsoft
70-458 · Question #35
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. The project is deployed to a single SSIS catalog, and transfers data to and from multiple…
The correct answer is A. For each target server, create separate Environments in the SSIS catalog of the host. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server. The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project. You need to meet the requirements by using the least amount of administrative effort. What should you do?
Options
- AFor each target server, create separate Environments in the SSIS catalog of the host
- BCreate one SSIS catalog Environment.
- CFor each target server, create separate registry entry configurations.
- DFor each target server, create a separate XML configuration file.
How the community answered
(65 responses)- A77% (50)
- B3% (2)
- C6% (4)
- D14% (9)
Community Discussion
No community discussion yet for this question.