Now, let's go back into our factory. As shown in the following screenshot, click on the + sign and choose pipeline from the contextual menu that appears. Rename it from pipeline1 to MainPilelineADFV2Book. Drag and drop an Execute SSIS Package activity on the pipeline area:

Click on the activity, make sure that the General tab is selected, and rename it ExecuteDailyLoad, as shown in the preceding screenshot.

Click on the Setting tab and set the properties to those shown in the following screenshot:

• Azure-SSIS IR: Select SSISIR from the drop-down list.
• 32-Bit runtime: Let it uncheck.
• Logging level: Choose Verbose from the drop-down list. We want to get the maximum information available in the SSIS logs, in case an error occurs.
• Package path: Type AzureDWDailyRefresh/Daily ETL/DailyETLMain.dtsx.
• Environment path: We're not using any environments; leave this textbox empty.

We're finished setting up the activity. We can now click on Debug, at the top of the pipeline window, to do a dry run of our package execution. Once we do it, the Execute SSIS Package activity gets a yellow icon, to indicate that it's executing. Also, the execution run's details appear at the bottom of the screen:

Once the execution has finished, we can see that it worked properly, as shown in the following screenshot:

That's it! We're able to call the data warehouse refresh from SSIS. Now, let's publish our pipeline to save it in ADF. Click the Publish All button to publish the newly created pipeline: