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).
Like this:
Select aLineOfText as theColumnName
From 'C:\Temp\MyFile.txt'
This could be the contents of the file: "Hello World!"
So when you run it, you get:
TheColumnName
-------------------
Hello World!
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.
Thanks!
Start Free Trial
