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.
SSIS deployment manifest
C.
msi
D.
ispac