I have a dynamic database that will be periodically queried to select
the data from a blob field. This blob data field is text of a variable
length. The data will be selected using an id field and a date range.
There will be multiple blob fields returned that I would like to output
into a txt file in a local folder.

I have the blob fields showing up as text in the field and not a
referring link. Can someone point me to an output to text solution?

Thanks

Hi

You could use BCP (or the textcopy sample) and the queryout arguement so you
can create a query on the fly using your identifiers. This could then be
call from xp_cmdshell. Or you could use a DTS package and specify the ids as
global variables or put them in a table where they can be picked up see
http://www.sqldts.com/default.aspx?234

John


"raglin" <pzelenka (AT) gmail (DOT) com> wrote