I'm no expert but I use this code and it works, if you're just dumping into one field to get it into the db

USE Databasename

DECLARE

@FilePath VARCHAR(1000) = 'c:\Transfer\' ,

@ArchivePathVARCHAR(1000) = 'c:\Transfer\Archive\' ,

@FileNameMaskVARCHAR(1000) = '*.txt'

DECLARE @ImportDate DATETIME

SELECT @ImportDate = GETDATE()

DECLARE @FileName VARCHAR(1000) ,

@File VARCHAR(1000)

DECLARE @cmd VARCHAR(2000)

CREATE TABLE ##Import (s VARCHAR(MAX))

CREATE TABLE #Dir (s VARCHAR(8000))

-- IMPORT FILE

SELECT@cmd = 'dir /B ' + @FilePath + @FileNameMask

DELETE #Dir

INSERT #Dir EXEC MASTER..xp_cmdshell @cmd

DELETE #Dir WHERE s IS NULL OR s LIKE '%not found%'

WHILE exists (SELECT * FROM #Dir)

BEGIN

SELECT @FileName = MIN(s) FROM #Dir

SELECT@File = @FilePath + @FileName

SELECT @file

SELECT @cmd = 'bulk insert'

SELECT @cmd = @cmd + ' ##Import'

SELECT @cmd = @cmd + ' from'

SELECT @cmd = @cmd +' ''' + REPLACE(@File,'"','') + ''''

TRUNCATE TABLE ##Import

-- IMPORT DATA

EXEC (@cmd)

-- REMOVE FILENAME JUST IMPORTED

DELETE#Dir WHERE s = @FileName

INSERT INTO tablename(fieldname)

SELECT s FROM ##Import

-- ARCHIVE FILE

SELECT @cmd = 'move ' + @FilePath + @FileName + ' ' + @ArchivePath + @FileName

EXEC MASTER..xp_cmdshell @cmd

END

DROP TABLE ##Import

DROP TABLE #Dir

GO

If you just create the Transfer & Archive folders named and put your text files into the Transfer folder it should work.