system.OutOfMemoryexception SSMS (SQL Server management studio) while importing file

Have you ever faced the frustrating scenario of importing a large CSV or flat file into an SQL Server table, only to be greeted by the…