How to read in a text file from a stored procedure

Question

I need to read in a log file created by a 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 issue it's not handling? Is there an easier way?

Answer 1

Have you tried a straight bulk insert? For example:

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