'Copying single csv with multiple schema in ADF

Hi I am trying to sink csv file to databse using ADF and Data Flow CSV file structure as below r1c1,r1c2,r1c3,r1c4

r2c1,r2c2,r2c3,r2c4

r3c1,r3c2,r3c3,r3c4

r4c1,r4c2,r4c3,r4c4,r4c5,r4c6

r5c1,r5c2,r5c3,r5c4,r5c5,r5c6

so 2 schemas one with 4 columns and second with 6 columns. My goal is to copy first 3 rows in one table and last 2 in second table. Please guide me to acheive this in ADF.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source