how to import file csv without using bulk insert query?
My answer is to work with bulk-insert.
1. Make sure you have bulk-admin permission in server.
2. Use SQL authentication login (For me most of the time window authentication login haven't worked.) for bulk-insert operation.
i have tried import file csv using bulk insert but it is failed, is there another way in query to import csv file without using bulk insert ?
so far this is my query but it use bulk insert :
bulk insert [dbo].[TEMP] from 

'C:\Inetpub\vhosts\topimerah.org\httpdocs\SNASPV0374280960.txt' with
  (firstrow=2,fieldterminator = '~', rowterminator = ' ');