After you've retrieved your CSV file, you could utilize nested BuildRowSetfromString() functions and a Script Activity in Automation Studio to accomplish what you've outlined. The outer loop would iterate through the rows and the inner one would iterate through the columns and add rows with the UpsertDE function.

I wouldn't be surprised if you would run into issues storing and parsing that much data.

Generally speaking, doing a FTP file drop and a File Import Activity is the more tried-and-true method of getting that data into the platform.

After you've retrieved your CSV file, you could utilize nested BuildRowSetfromString() functions and a Script Activity in Automation Studio to accomplish what you've outlined. The outer loop would iterate through the rows and the inner one would iterate through the columns and add rows with the UpsertDE function.

I wouldn't be surprised if you would run into issues storing and parsing that much data.

Generally speaking, doing a FTP file drop and a File Import Activity is the more tried-and-true method of getting data into the platform.