Post reply

Dtsrun.exe without SQL2000

  • November 28, 2006 at 3:03 am

    #67890

    Hello,

    I have an issue : On a server (A) I installed SQL2000 and on the other server (B) I don't installed it.

    I want run DTSrun with server A path on server B, but the problem is that in DOS this command don't exit.

    Thanks

    Marco

  • November 29, 2006 at 3:28 am

    #674614

    Have a look here to start

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

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

  • November 29, 2006 at 7:06 am

    #674638

    I am not 100% sure - but I'm pretty sure - that an easier way to get DTSrun available on a server B is to start to install SQL Server the and just select the option for client tools only (can't remember this process well enough to give specific instructions).  It also loads up enough libraries, tools and whatnot for VB / Dot-Net development.  You can also install BooksOnLine as part of a client-only install and that can be helpful.

    Then you'll have to look up the syntax for the DTSrun command to figure out how to use it.  Probably you'll do something like:

    dtsrun /S A /E /N "Package Name"

     

  • November 29, 2006 at 9:16 am

    #674697

    You could also try using the task scheduler. It should give you the option of ending the task after a specified amount of time.

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

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