Basically I am looking for some help to read the data from the Oracle source and write it to flat file in the .json format. Since there is a hug volume of data, data should be split into multiple json files. And once the process is completed, need to generate a completed file with number of rows processed

Used data flow task and selected oracle source. Need a c# logic to convert the data into json format and write to a file.