title: How to read in a text file from a stored procedure
body: <p>I need to read in a log file created by a SSIS package in my stored procedure.</p>
  
  <p>Is there a good way to do this?</p>
  
  <p>I tried using <a href="http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/" rel="nofollow noreferrer">this code</a> 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?</p>