I’m trying to loop through a folder of large CSV files and load the data into a SQL database. The tricky part is each CSV file has around 250K rows of data.
Can someone please explain the Activity workflow? I understand the basic workflow is Connect to SQL => Read CSV => Insert to SQL.
I believe there is a limit to the number of Rows in the insert activity. I also need to add a loop for each file.