Post reply

MANUAL RUN OF SAVED DTS

  • January 16, 2006 at 8:20 am

    #60309

    I want to save a DTS (text to Microsoft ODBC driver for SQL SERVER) and be able to run int manually again.

    How should I save it and how do I re-run it again?

  • January 16, 2006 at 11:17 am

    #614967

    I'd probably save it on the SQL Server and run it again using Enterprise Manager to navigate to the DTS Packages folder, then run the package (either right-click to run or open and run).

    -Pete

  • January 16, 2006 at 11:49 am

    #614978

    That was it, many tahnks

     

  • January 17, 2006 at 2:27 am

    #615068

    Hi, you could also use the DTS run utility from the DOS command line prompt.

    I have used this to allow users to run packages on demand without them having access to SQL Server (or even being aware of what they are doing) by giving them a nice button on their desktop that says "Press this now!" - or whatever.

    See BOL for full explanation and list of arguments.

    Hope this helps.

     

    All the best,

    Duncan

  • January 17, 2006 at 6:30 am

    #615119

    Many thanks for your help

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

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