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:

3. 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.
4. Expand SSISDB, and select the DWDailyRefresh folder. We created that folder earlier.
5. Click OK to close that window:

6. Back on the Select Destination window, click Next.
7. The next step is to validate. On-premises deployments don't use it, however.
8. Click Next to proceed to the Review window, as shown in the following screenshot. Here, we review whether we have selected the right .ispac file and confirm that we are going to deploy it to the right folder in SSIS, as shown in the following screenshot.
9. Once done, we click on Deploy to start the deployment of the .ispac file:

10. The last step, Results, shows the progress of our deployment. If everything is successful (as it should be), click the Close button:

We're now done with the deployment.

11. The next step is to execute the package via the catalog. We'll switch to SQL Server Management Studio for that.
12. In the object explorer, expand the Integration Services Catalogs, and navigate through the DailyETLMain.dtsx package.

13. Right-click on it and select Execute... from the contextual menu that appears:

The execution window will appear.

14. Go to the Connection Managers tab, as shown in the following screenshot.
15. Check the Connection String property for both connectors, and adjust them if necessary.
16. When everything is okay, click on OK to start the package execution:

17. Click Yes to see the report.

Once the report has opened, we might notice that the package is still running, but when we refresh it, we will see the result, as the package executed with success: