Using user input in an ActiveX task

• slider

  SSC Enthusiast

  Points: 114

  More actions

  May 20, 2004 at 11:54 am

  #60104

  For a package that is only ever going to be run manually is there any way for me to pop up a box allowing user input and then use that value inside the script?

  TIA.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 20, 2004 at 2:34 pm

  #507186

  Try this example from SQLDTS.com:

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

  It has a downloadable package template that you can change to suit your needs.

  Greg

  Greg

• bellis

  SSCarpal Tunnel

  Points: 4667

  More actions

  May 21, 2004 at 7:33 am

  #507270

  You can do this in an ActiveX Script like below...

  Function Main()

       Dim myYearQtr

       myYearQtr = InputBox ("Enter the date you would like to extract data for.", "Extract Data","4Q2003")

       DTSGlobalVariables("myYearQtr").Value = myYearQtr

       Main = DTSTaskExecResult_Success

  End Function

  You can then use the global variable that is set anywhere in the DTS.