DTS Status Message

• Sam Alibrahim

  Newbie

  Points: 9

  More actions

  February 9, 2005 at 11:49 am

  #60980

  Hi,

   

  Is there a way to display a status message or progress feedback to users in DTS SQL 2000 using VBScript without having the user to acknowledge the message, i.e. no buttons in the message window similar to MsgBox().

   

  Thanks,

• AngPeng

  SSC-Addicted

  Points: 489

  More actions

  February 10, 2005 at 6:44 am

  #541557

  You can use a Window Script Host popup methode to popup a message and the message box will terminate itself after a defined time (second).

  This methode is not an Event driven.  You have to plan out the time for the Message box to close.

  Dim WshShell

  Set WshShell = WScript.CreateObject("WScript.Shell")

  ' Displays a message for 3 seconds

  WshShell.popup "Hello", 3