Stored proc's + Recordsets = Files??

[Gaurav]

Hi,
I have just started on SQL 7, and was looking for a particular functionality in it that i know Oracle provides via pl-sql.

Lets assume I have a Stored proc' that fires a query which in turn returns a single row recordset. Now i would like to persist this recordset to a file? It must be done within the SP, I realise this could easily be done using ADO clients. But can i do it completely in the backend via SQL7 itself?

Any pointers in the right direction for this would be MOST helpful! Thank you.

Regards,
Gaurav

[Dr_Evil]

If you wish to store a resultset in a user file you may want to look into using Data Transformation Services (DTS) or possibly the bulk copy method. It may take a little more effort but both of these can be executed from within a SP.
Hope this has pointed you in the right direction.

[Gaurav]

Hiya,
Well it does a little... but a lot of people tell me that via SQL7 one cannot write directly to a file.. is this true?? have u eer done or heard of this being done??? And i haven't worked in DTS so could u PLEASE send me some more details..?? I know i'm pushing my luck here :) but do help!!! :)

Thanks
Gaurav