ALTER proc [dbo].[usp_test]
AS
   IF OBJECT_ID('tempdb..#promo') is not null BEGIN
      DROP TABLE #promo
   END

   CREATE TABLE #promo (promo VARCHAR(1000))

   BULK INSERT #promo
   FROM '\serverc$file.txt'
   WITH
   (
      --FIELDTERMINATOR = '',
      ROWTERMINATOR = 'n'
   )

   select * from #promo