In a Stored Procedure, Select from a text or XML file
Posted on 2006-05-10
I need to get a value from a plain, old text file into my stored procedure. By "text" I mean a word, not like image or binary or blobs or text as in memo (msaccess term).
Select aLineOfText as theColumnName
This could be the contents of the file: "Hello World!"
So when you run it, you get:
1 row(s) affected.
Seems simple. I must be missing something.
I thought OpenXML might do it, but it doesn't seem to read from files. This is not part of a DTS package.