Post reply

Can DTS be used to invoke .bat file?

  • January 19, 2006 at 9:09 am

    #67284

    Hi,

    I have a job to be scheduled each month. But the task is java dependent also.

    Is it possible to do this scheduling using DTS package.. like DTS package which can have .bat file containing my java code to access the application and get it schedule each month.

    Thanks,

    Pradeepa

  • January 19, 2006 at 9:21 am

    #615841

    You may try the 'Execute Process' task in DTS.  This should allow you to call a .bat file.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • January 19, 2006 at 11:05 am

    #615879

    Yes, it does..we use it in a lot of places.

  • January 20, 2006 at 7:24 am

    #616066

    Absolutely! You just have to make sure that the user that runs the DTS package has access to run that .bat file. Also, make sure that the .bat file is located on the same server as SQL Server, or that the network path to the file and share permissions are correct.

  • January 21, 2006 at 9:51 am

    #616271

    you can write the script to call the .bat file

    Everything you can imagine is real.

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

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