How to read in a text file from a stored procedure

Question

I need to read the log file generated by the SSIS package in my stored procedure.

Is there a good way to do this?

I tried using this code , but it shows the contents of my file as jibberish. Is there some kind of encoding problem that it doesn't handle? Is there an easier way?

Answer 1

Have you tried the inline insert? For instance:

create table #TempTable (line varchar(256))
bulk insert #TempTable from 'c:\logfile.txt'

Answer 2

You can try

select * from OPENROWSET(BULK N'C:\logfile.txt', SINGLE_BLOB)

Answer 3

, , !

, , , , .

, , , CLR SQL Server. , .NET

MSDN Link 1 MSDN 2

, , , CLR SQL Server