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
