Post reply

DTSRun utility from Command prompt

  • November 17, 2004 at 11:44 am

    #102281

    I have a DTS package on a SQL 2k server. I need to have a user be able to run this package from her workstation. However, I dont want to load the client on her machine.

    What are files or libraries required so that I can just give a batch file to execute which in turn calls and runs the DTS package using the DTSrun utility.

    Any help or thoughts on this is much appreciated.

    Thank you.

     

     

     

  • November 17, 2004 at 12:38 pm

    #530538

    Can you have this DTS package scheduled?  Is it possible that you have a web server and can perform this from the web?

    If the user is supposed to run the package why the concern about the client?

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • November 17, 2004 at 1:17 pm

    #530543

    I use the DTS to format a file. The user need not know how the formatting is done - or rather, I want to make it as simple as possible for the user.

    I have created a batch file with multiple steps(dtsrun being one of them). Yes, I can schedule these steps as a job but the user need to maintain the control on when it need to be run. Hence the batch file. Its easier that way.

    Thanks.

  • November 17, 2004 at 5:14 pm

    #530568

    How bout granting access to a scheduler task on the server that the user can modfiy the schedule?  This way the job will be activated from the server and the user is none the wiser on what is really going on.

    We currently have NT scheduled tasks that run batch files here and it works like gang-busters.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • November 18, 2004 at 7:03 am

    #530647

    Take a look at this site.

    http://www.sqldts.com/default.aspx?225

     

  • November 18, 2004 at 7:29 am

    #530662

    Thank you.

    This is exactly what I was looking for. A list of files needed to run the DTS from a wrkstation without installing the whole client.

  • November 18, 2004 at 2:36 pm

    #530735

    I'd try to setup a web page to execute a scheduled job that runs the package. Nothing to install on the client machine then. One less thing to worry about when the client machine is upgraded.

    --------------------
    Colt 45 - the original point and click interface

  • November 18, 2004 at 2:40 pm

    #530738

    In that case, how would I go about doing that? I have not done anything like that before.

    Thank you.

Viewing 8 posts - 1 through 7 (of 7 total)

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