Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – executing an SSIS package from a catalog

After deploying the project, we can execute the Master Package. Before executing the Master Package, revert all the changes, which means move customer CSV files from the Archive folder back to the source folder, and truncate the customer and log database tables. To get this sample working, you will need to have the project deployed to SSIS Catalog, as illustrated in the previous sample, and perform the following steps:

1. In the SSMS, under Integration Services Catalogs, under SSISDB, expand the Packtpub_BI_2014 folder and then expand the packages under the Chapter 04 Integration Services project. Then, right-click on the Master Package and click on Execute.
2. In the Execute Package window, go ...