You create 25 Microsoft SQL Server 2005 Integration Services (SSIS) packages on the development server. You decide to deploy the SSIS packages on the test server. You need to create a repeatable process that will allow you to deploy the packages to the package store on the test server if the packages change.
You also need to ensure that this is achieved with minimum effort. What should you do?
A.
Use Microsoft SQL Server Business Intelligence Development Studio (BIDS) to save each package to the remote server.
B.
Use the dtutil utility in a batch file to deploy each of the package .dtsx files to the remote server with the /Fi option.
C.
Copy the Microsoft SQL Server Business Intelligence Development Studio (BIDS) files to the remote server and build the SSIS project on the remote server.
D.
Create a package deployment utility in Microsoft SQL Server Business Intelligence Development Studio (BIDS) and use the Deployment Wizard to deploy all the packages.