Erland,

I decided to try your approach and in the preliminary tests the results are better than I expected.

A simplified version of my script is as follows:

--Beginning of sample script---

DECLARE @File_Content...

Thank you Erland. I will take a look at the approach you recommended. My concern as you mention in your article is performance. Some of the files...

-----Create Schema------

CREATE SCHEMA Master_Data;

------Create Table---

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [Master_Data].[File_Load](

[Load_ID] [bigint] IDENTITY(1,1) NOT NULL,

[File_Record] [varchar](max) NOT NULL,

[IsError] [bit] NOT NULL,

CONSTRAINT [PK_MMR_File_Load] PRIMARY KEY CLUSTERED

(

[Load_ID] ASC

)WITH...

Same database. Running T-SQL statement directly from SSMS. Run as Windows Login and as 'sa'. Same result.

Same server.