Integration of CSV file from ADLS to Azure SQL DB using ADF
How to create Linked Services for ADLS2 in ADF
Step 1: Click on New from Connections section at the Bottom to create a new Linked service.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/1-1-1024x486.png)
Step 2: Select ADLS Gen 2 and click on continue.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/2-1.png)
Step 3: Enter the details as follows and click on Test Connection and Click Create.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/3-1.png)
Note: Similarly create a new LS for Azure SQL DB.
How to create Dataset for ADLS2 in ADF
Step 1: Click on New dataset from Datasets section.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/4-1-1024x489.png)
Step 2: Select ADLS gen 2 option and click on Continue.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/5-1.png)
Step 3: Select Delimited Text and click on continue.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/6-1.png)
Step 4: Enter Details and Click on browse.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/7-1.png)
Step 5: Select Categories.csv file from your container and click on ok.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/8-1.png)
Step 6: Select other details as shown for First Row as header and Import Schema options.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/9-1.png)
How to create a pipeline in ADF
Step 1: Click on New Pipeline from the ‘+’ icon at the top and give it a suitable name.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/10-1-1024x475.png)
Step 2: Select the Copy Activity from Move and Transform section.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/11-1-1024x536.png)
Step 3: Select the Copy Activity from Move and Transform section.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/12-1-1024x489.png)
Step 4: Configure the Source and Sink as follows.
Source:
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/13-1.png)
Sink:
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/14-1.png)
Step 5: Click on Debug and check the output.
![](https://www.cloudfronts.com/wp-content/uploads/2020/07/15-1-1024x481.png)