CREATE PROCEDURE [dbo].[usp_SurveyImport]
	
AS

Begin
BULK INSERT [tbl_SurveyRecipient]
    FROM '\\server3\sites\admin\imports\contacts.txt'
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = '|', 
        ROWTERMINATOR = '\n' 
    )
End
GO