Post reply

DTSRUN.exe utility

  • July 22, 2008 at 1:57 pm

    #191388

    What are the permissions required to run dtsrun.exe utility in sql server 2000 server?

    MJ

  • July 23, 2008 at 12:52 pm

    #847308

    I would say Process Administrators.

  • July 23, 2008 at 4:09 pm

    #847434

    Thanks for the reply. What if in case I need to call dtsrun.exe(located on sql server) from a batch file that is present on some other application server?

    Please suggest.

    Manu

  • July 24, 2008 at 4:04 am

    #847609

    I used to install the files required to run dtsrun on the machines that needed it ( I got the list of files from http://www.sqldts.com/225.aspx). Used the dtsrunui to create an encrypted command line, copy and paste it into a batch file then the users could run it.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • July 24, 2008 at 9:56 am

    #847903

    If batch file is on the same server where sql server is also installed then what permissions do I need to provide to a user who wants to execute it from batch file using dtsrun /S ServerName /U Username /P password /N Package Name command in batch file?

    Thanks for your replies..

    Manu

  • July 27, 2008 at 8:32 pm

    #848941

    If you would like to trigger the DTS utility from another site, you may need to grant your account the process administrators.

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

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