You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You
currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes
existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and
requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Use a project deployment model. Change the command shell scripts to reference the SQL
Server 2012 path to dtutil.
B.
Use a package deployment model. Use the Integration Services Deployment Wizard.
C.
Use a package deployment model. Change the command shell scripts to reference the
SQL Server 2012 path to dtutil.
D.
Use a project deployment model. Use the Integration Services Deployment Wizard.
B.