Step 1: Building the Deployment Utility
Applies To: SQL Server 2016
In this task, you will configure and build a deployment utility for the Deployment Tutorial project.
Before you can build the deployment utility, you must modify the properties of the Deployment Tutorial project. You will use the Deployment Tutorial Property Pages dialog box to configure these properties. In this dialog box, you must enable the ability to update configurations during deployment and specify that the build process generates a deployment utility. After you set the properties, you will build the project.
SQL Server Data Tools (SSDT) provides a set of windows that you can use to debug packages. You can view error, warning, and information messages, track about the status of packages at run time, or view the progress and results of build processes. For this lesson, you will use the Output window to view the progress and results of building the deployment utility.
If SQL Server Data Tools (SSDT) is not already open, click Start, point to All Programs, point to Microsoft SQL Server, and then click Business Intelligence Development Studio.
On the File menu, click Open, click Project/Solution, click the Deployment Tutorial folder and click Open, and then double-click Deployment Tutorial.sln.
In Solution Explorer, right-click Deployment Tutorial and click Properties.
In the Deployment Tutorial Property Pages dialog box, expand Configuration Properties, and click Deployment Utility.
In the right pane of the Deployment Tutorial Property Pages dialog box, verify that AllowConfigurationChanges is set to true, set CreateDeploymentUtility to true, and optionally update the default value of DeploymentOutputPath.
In Solution Explorer, click Deployment Tutorial.
On the View menu, click Output. By default, the Output window is located in the bottom left corner of SQL Server Data Tools (SSDT).
On the Build menu, click Build Deployment Tutorial.
In the Output window, verify the following information:
Build started: SQL Integration Services project: Incremental ...
Creating deployment utility...
Deployment Utility created.
Build complete -- 0 errors, 0 warnings
========== Build: 0 succeeded, 0 failed, 1 up-to-date, 0 skipped ==========
On the File menu, click Exit. If prompted to save changes to Deployment Tutorial items, click Yes.