Showing posts with label dos. Show all posts
Showing posts with label dos. Show all posts

Monday, March 26, 2012

Running a .rpt file from dos

Can someone tell me if it's possible to run a CR .rpt file from the MS DOS command line? I'd like to run it (in a .bat file) and then save the output, to disc.I wonder if there is a way to do this
Why dont you use Export functionality?|||Hello Madhi: Can you elaborate on your idea? How would I invoke the Export functionality, from DOS?|||Open the report and from export option export the data|||What syntax do I use? I want to do this from the command line, not from within the IDE.

Saturday, February 25, 2012

run a dos command?

Hi all,
I am just wondering is there a way to run a dos command in the stored procedure? Please fill me in on how to go about doing if is there is a way. If this is not the correct forum to post this question, please let me know. Thanks in advance.
Daren

Hi faren,

you can open up a shell with XP_cmdshell and execute commands via passing the command as a paramter:

EXEC MASTER.XP_CMDSHELL 'dir C:\'

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de