Post reply

help me

  • December 18, 2002 at 7:54 pm

    #80092

    how to run '*.exe' files or '*.bat' files in sql server?

    thanks.

  • December 18, 2002 at 8:11 pm

    #444774

    Depends on several factors but the key is once you start an exe or bat SQL will not retain control over in many cases. One method is to use xp_cmdshell to execute them. What are you specifically trying to accomplish and are you sure that it will do exactly what you want?

  • December 18, 2002 at 10:38 pm

    #444779

    i want to create a job to put some data into 'work.xls' every day.

    so i think it's nessary to run '*.exe' or '*.bat' in sql server.

    thanks.

  • December 19, 2002 at 1:59 am

    #444781

    The most usual way to output data from SQL Server to an Excel file would be to use a DTS Package.

  • December 19, 2002 at 4:19 am

    #444790

    Yes, using DTS you can process the file much easier and if you need to run every day you can schedule as a job thru SQL Agent which means you have much better control over the process.

  • December 19, 2002 at 5:04 pm

    #444887

    thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply