I want to read a large csv file that is approximately 1GB in size. I’m getting an issue when I try to use the read csv activity. can anyone give me the suggestion for that?
- You can use the Read CSV activity with by setting the chunk size property in the read csv activity.
- Use the Read Text File activity to read the CSV file as a text file. Then, split the text into chunks using the String Manipulation activities, such as Substring or Split.
You can try to use VB or C# code to read your CSV file since it’s large in size, here’s a link that’ll help you:
You can also try out the approach given by @Pallavi_Shirodkar1!
Check out this video link
Thread : Issue while reading large CSV file
Hey @Anish_Kumar2 ,
Kindly refer below Thread
Hope it helps you out!