<div>
you can try this option Getting Text into a Table 
 

<pre><code class="code-10 nolinks" id="code-20-39894428-1">DECLARE @LotsOfText NVARCHAR(MAX),
 @ii INT,
 @iiMax INT,
 @File VARCHAR(2000)
DECLARE @files TABLE (MyID INT IDENTITY(1,1) PRIMARY KEY, [Path] VARCHAR(2000))
DECLARE @lines TABLE (MyID INT IDENTITY(1,1) PRIMARY KEY, [line] NVARCHAR(MAX))

DECLARE @FileList XML
EXECUTE ListPathsXML 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.*',
 DEFAULT , @XMLFileList = @FileList OUTPUT

INSERT INTO @files(path)
 SELECT x.thefile.value('fullpath[1]', 'varchar(2000)') AS [path]
 FROM @FileList.nodes('//thefiles/thefile') AS x ( thefile )
DELETE FROM @files WHERE REVERSE(path) LIKE 'golrorre%'
--don't look at the current errorlog!
SELECT @ii=1, @iiMax=MAX(MyID) FROM @Files
WHILE @ii&lt;=@iiMax
 BEGIN
 SELECT @File= [path] FROM @files WHERE MyID=@ii
 INSERT INTO @lines(line)
 EXECUTE spLoadTextFromAFile @file, @Unicode=1
 SELECT @ii=@ii+1
 END
SELECT MyID AS [line Number], Line, @file FROM @lines
 WHERE line LIKE '%Error%' 
</code></pre>
 
refer for more deatils , this will contain all options 
<a href="https://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/" rel="ugc">https://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/</a>
</div>

<div>
Thanks Pratima, sorry for the delay in getting back. 
 
As soon as I have 5 minutes I'll check this out. 
 
Thanks again, 
 
Paul.
</div>

<div>
But doesn't &quot;ListPathsXML&quot; use xp_cmdshell? 
 
What is wrong with &quot;OPENROWSET( BULK&quot;?
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
Does anyone know if it is possible to load a file from the file system hosting an sql express instance (so no SSIS) into a SqlString using only TSQL without using xp_cmdshell or OPENROWSET(BULK. 
 
Also CRL Integration is disabled. 
 
Mission Impossible? 
 
Paul Cookson
</div>
</div>

Hi,

Does anyone know if it is possible to load a file from the file system hosting an sql express instance (so no SSIS) into a SqlString using only TSQL without using xp_cmdshell or OPENROWSET(BULK.

Also CRL Integration is disabled.

Mission Impossible?

Paul Cookson

Load file into SqlString variable using only TSQL.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.