You need to configure the SQL Server environment tosupport these packages

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server.
The SSIS packages use the Project Deployment Model together with parameters and Integration Services
environment variables.
You need to configure the SQL Server environment tosupport these packages.
What should you do?

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server.
The SSIS packages use the Project Deployment Model together with parameters and Integration Services
environment variables.
You need to configure the SQL Server environment tosupport these packages.
What should you do?

A.
Create SSIS configuration files for the packages.

B.
Create an Integration Services catalog.

C.
Install Data Quality Services.

D.
Install Master Data services.



Leave a Reply 1

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


Fatima

Fatima

This question is part of 70-463