DECLARE @FilePath NVARCHAR(100)
CREATE TABLE #TempProcessFile

(

City NVARCHAR(100),

State NVARCHAR(100),

Country NVARCHAR(120)

)

SET @FilePath = 'D:\test20120402.txt'

--I assume you have comma seperated row values.

exec('BULK INSERT #TempProcessFile FROM ''' + @FilePath + ''' WITH ( FIRSTROW = 1,  FIELDTERMINATOR = '+''',''' + ', ROWTERMINATOR = '+'''\n'')')
--print('BULK INSERT #TempProcessFile FROM ''' + @FilePath + ''' WITH ( FIRSTROW = 1, LastRow = 10 , FIELDTERMINATOR = '+''',''' + ', ROWTERMINATOR = '+'''\n'')')

select * from #TempProcessFile
select * from #TempProcessFile FOR XML PATH

DROP table #TempProcessFile