Stored Procedure - Writing output in a text file

[Former Member]

Hi All,

I want to write the required data in a text file at a particular location on server.

How to achieve this ?

Regards,

Nikhil

[former_member583013]

Are you using any Scripting Language to achieve this? Otherwise, please tell me to move this thread to a more suitable forum -:)

Greetings,

Blag.

[Former Member]

Hi,

I am using Shell Script to load data in a temporaryy table. Then, I am using stored procedure to filter that data in comparison with another table data. The filtered data needs to be written in a file.

Regards,

Nikhil

[script_man]

Hi Nikhil,

perhaps my example will help you further:

set Wshell = CreateObject("WScript.Shell")

Set fso = CreateObject("Scripting.FileSystemObject")

set TextFile = fso.CreateTextFile("c:\tmp\Text.txt", True)

TextFile.WriteLine "Text"

TextFile.Close

Regards,

ScriptMan

[former_member583013]

Thanks -:) Just needed to be sure -;) Sorry I can't help you further as I'm not used to Script Shell...

Greetings,

Blag.