USE Bible;
GO

CREATE table dbo.FileLists
(
	ID INT NOT NULL IDENTITY PRIMARY KEY,
	FilePath NVARCHAR(128),
)


CREATE TABLE dbo.ImportedTextFile
(
	ID INT NOT NULL IDENTITY PRIMARY KEY,
	FilePath NVARCHAR(128),
	CONTENT NVARCHAR(MAX)
);
GO
-- Insert a sample record
INSERT INTO dbo.FileLists(FilePath) VALUES ('C:\Bible\list.txt');
GO

-- Read a sing text file based on file path and reture the text file content
CREATE PROCEDURE dbo.ReadSingleTextFile
(
	@FilePath NVARCHAR(128),
	@FileContent NVARCHAR(max) output
)
AS
BEGIN
	SET NOCOUNT ON;
	CREATE TABLE #Temp(Content nvarchar(max))
	EXEC('BULK INSERT #Temp FROM "' + @FilePath + '"');
	SELECT  @FileContent = Content FROM #Temp
	DROP TABLE #Temp
END
GO

-- Read all files into a table based on a list of file paths in aother table
SET NOCOUNT ON;

DECLARE @FilePath nvarchar(128);
DECLARE @Content nvarchar(max);

DECLARE FilePath_Cursor CURSOR FOR SELECT FilePath FROM dbo.FileLists;

OPEN FilePath_Cursor;

FETCH NEXT FROM FilePath_Cursor INTO @FilePath;

WHILE @@FETCH_STATUS = 0
BEGIN
  EXEC dbo.ReadSingleTextFile @FilePath, @FileContent = @Content output;
	INSERT INTO dbo.ImportedTextFile(FilePath, Content) VALUES(@FilePath,@Content)
	FETCH NEXT FROM FilePath_Cursor INTO @FilePath;
END
CLOSE FilePath_Cursor;
DEALLOCATE FilePath_Cursor

-- Test the result
SELECT * from dbo.ImportedTextFile

C:\Bible\1chron.txt
C:\Bible\1corinth.txt
C:\Bible\1john.txt
C:\Bible\1kings.txt
C:\Bible\1peter.txt
C:\Bible\1samuel.txt
C:\Bible\1thess.txt