I am new to database,I am using SSMS 2008 R2 to import 2GB of data from a .csv file.
It is taking around 115mins to import.
Can anybody let me know any better way to perform this import.
You should show the definition of the table(s) involved, how the data is clustered, how many indexes it has, ... and some indication of the hardware on which the database it's running, to help assess whether 115 mins is considered normal or not.
Not only that.... what code are you using to import it? As far as we can tell you're just typing it in manually.
You need to use bcp.exe or SSIS. Read Import and Export Bulk Data by Using the bcp Utility (SQL Server) and The Data Loading Performance Guide. Also, read How to Analyze SQL Server Performance to be able to tell why something is slow.
After you've read those, come back with a more actionable question, including structure of table, csv structure, repeatability of the job, access issues etc.