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:
In the SSMS, under Integration Services Catalogs, under SSISDB, expand the
Packtpub_BI_2014folder and then expand the packages under the Chapter 04 Integration Services project. Then, right-click on the Master Package and click on Execute.In the Execute Package window, go to the Connection Managers tab. You will see all the connection managers here and you will be able to change the properties of the connection managers from this GUI tool. Just leave the configuration as is.
Go to the Advanced tab and change the Logging...