Post reply

Can DTS packages take a user-defined variable?

  • March 6, 2003 at 1:42 pm

    #159267

    I have a DTS package that needs to execute based on a date range that is given by the user. Is there any way to accomplish this?

    chris

  • March 6, 2003 at 3:23 pm

    #450471

    How does your package execute? If it executes interactively, you can use inputbox to request the parameters from the user.

    If it's non-interactive, you could store the parameters in a table and pull them in using Dynamic Properties task (SQL2K), or an Execute SQL task.

    Either way, you would assign the resulting input to global variables and then use them as necessary.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    Edited by - phillcart on 03/06/2003 3:25:14 PM

    --------------------
    Colt 45 - the original point and click interface

  • March 6, 2003 at 3:25 pm

    #450472

    You can pass in user defined values to DTS packages via Global Variables. Look in Books On Line (SQL Server help) for Global Variables. A simple prompt to the user for the variable values could be handled via an input box in an ActiveX script.

    hth,

    Michael

    Michael Weiss


    Michael Weiss

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

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