I have a new requirement. we have folder contains more than 500 csv files with same structure . each file contains more than 2 million records . using SSIS ,time takesn for one file to import around 4 s. my requirement is i want to import all the files in the folder with in below 10 sec. Is there any way to acheive this . please advise ?
structure of file
Sdate ,startValue ,endValue, adjustedValue