Your team is creating SQL Server Integration Services (SSIS) packages that have several
dependencies. The packages use parameters for configuration purposes.
Your company’s IT policies include the following change control requirements:
After a package is ready for deployment, your team must hand over the process to junior IT
personnel.
The process must guarantee that when a package has been validated, that same package
(and all its dependencies) is deployed to production.
The process must be repeatable and reliable and must be executed with the least
administrative and training effort by junior IT personnel.
You need to use the most appropriate deployment unit to satisfy the company policies, while
minimizing issues such as incorrect version or configuration.
Which type of deployment unit should you use?
A.
dtsx
B.
SSISdeploymentmanifest
C.
msi
D.
ispac