PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package must be deployed on 10 servers. You do not have access to the file system on any of these 10 servers. You need to set different package configuration properties at the package run time. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create an XML configuration file. Select the XML configuration type in the SSIS Package Configurations Organizer.

B.
Create a batch file that uses the dtutil utility program to set the package configuration properties while the package deploys into production.

C.
Use the SSIS Package Configuration Wizard to create a SQL Server Configuration type. Select a centralized Microsoft SQL Server to store the package configuration properties.

D.
Create a .REG file that contains entries for each of the configuration properties. Select a single Registry Configuration type in the SSIS Package Configurations Organizer.


Leave a Reply