Output Select results to a text file.

[raglin]

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

[John Bell]

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" <pz******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

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