All the steps we took in the previous section were preparing the copy activity we're going to do in this section. What we have done manually so far is essentially take the same steps that the copy activity wizard would have done. Since we're now more familiar with ADF, it's good to do it manually to better understand all the steps of a copy activity process.

We'll now add a new pipeline to our factory. We could work from the one we created to hold our Execute SSIS package activity, but since we want to test and debug the new code, it's easier to use another pipeline. If we don't do it, we would have to execute all the pipeline every time we want to test a single activity. Once we are satisfied with our work, we will copy/paste it back into the main pipeline.

Drag a Copy activity from the Dataflow section of the activities. Name it Copy_ADFFV2Book_Sales_Blob, as shown in the following screenshot:

Click on the Source tab and, using the drop-down list, select the ADFV2Boook_Sales_Source in the Source Dataset, as shown in the following screenshot. This is the dataset that is linked to the ADFV2Book.Sales view in SQL Server on-premise:

Click on the Sink tab and select ADFV2Book_Sales_Destination as the Sink Dataset. Your screen should look like this screenshot:

Now, click on Debug at the top of the factory. It's the icon that looks like the following screenshot:

The pipeline will execute in a debug environment. Nothing will be copied for real, but just executed to ensure that everything works properly. If that's the case, as shown in the following screenshot, you will see the execution results:

If you click on the small glasses icon as highlighted in the previous screenshot, you will see more details about the activity execution, as shown here: