Azure Data Factory - Foreach for multiple CSV

Shah, Sapana N 1 Reputation point
2021-03-03T21:58:08.36+00:00

Hello, I need to load multiple csv files from ADLS to SQL Db. For pipeline I am using lookupfiles to get the file list and than passing it to foreach. Within foreach I am using copydata. But i am getting error as each csv file has two extra lines of data before header starts. If i use skip line count within copydata than pipeline is throwing an error. Copy data for the same source and sink works without an error for single file but not within foreach. Any suggestion please ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,190 questions
{count} votes