Hi @Mahesh Kumar ,
Thanks for reaching out.
Since your row1 is header and you want to skip 2nd and 3rd rows, you can utilize the
skipLineCount property available in Copy activity source settings.
- First you will have to select
firstRowAsHeaderproperty in dataset connection settings as shown below:
- Second, in the copy activity source settings, set
skipLineCount = 2this will skip the first 2 rows (in your case 2nd and 3rd row data excluding the header row i.e., 1st row as you have selected
firstRowAsHeaderproperty in dataset connection settings)
- In the mapping section do import schemas.
I have tested this scenario and works as expected.
Here is the source blob used:
Here is the sink table after loading data:
Ref doc: Copy activity properties
Hope this info helps. Do let us know how it goes.
Please don’t forget to
Accept Answer and
Up-Vote wherever the information provided helps you, this can be beneficial to other community members.