To demonstrate an import a csv file into SQL Server I will use the following data set:
Open Sql Server Management Studio(SSMS) , go to your database you want to import the data(In my case I have created a database called Parking).
Right click on the database >> Tasks >> Import Data...