Post reply

Changing DTS to read-only, at runtime

  • September 21, 2004 at 6:18 am

    #59985

    Hi,

    I want to make a DTS package read-only, or do something to prevent it being run by another user on the server, when it is executed.

    I am sure there is a simple piece of code to achieve this; does anyone know it at all??

     

    Thanks!

  • September 22, 2004 at 6:29 am

    #523960

    Processes recorded in master.dbo.sysprocesses which are running DTS pkgs have program_name='DTS Designer' but you can't tell which DTS pkgs they are running, so checking the processes will not help.  Also, once the pkg is "loaded" and started running there's no locks to check on msdb.dbo.sysdtspackages. 

    You can have the DTS pkg create a file as it's first task and delete it as the last task.  You'll also need to handle deleting this file if any other tasks (except for the 1st task which creates it) fail before the pkg finishes. 

    Jeff

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

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