Deploying the project on-premises

We're now ready to deploy and test our project on our local server:

  1. From the Solution Explorer, right-click on the project, WWImportersDaily, and choose Deploy. The Integration Services Deployment Wizard appears, as shown in the following screenshot.
  2. Click Next to proceed to the next step:
  1. Connect to your SQL Server, where the integration services catalog was created before, and click Browse.... The Browse for Folder or Project window will open.
  2. Expand SSISDB, and select the DWDailyRefresh folder. We created that folder earlier.
  3. Click OK to close that window:
  1. Back on the Select Destination window, click ...

Get Hands-On Data Warehousing with Azure Data Factory now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial