Post reply

Parameters in DTS

  • July 13, 2006 at 9:00 am

    #69132

    I have a DTS package and it runs great except that I have to go into the design and change dates each time I run it. 

    I would love to execute the package and have it prompt me for the date range and then pass the dates to the package.

    Any assistance would be greatly appreciated.

  • July 13, 2006 at 9:54 am

    #649018

    for this first u need to declare to Gloable variable StartDate and EndDate for taking the date range and the u can use the follwing code in the activeX script to prompt for dates

    DTSGlobalVariables("StartDate ")=InputBox("Enter your startDate in the format mm/dd/yyyyy")

     

    DTSGlobalVariables("EndDate ")=InputBox("Enter your EndDatein the format mm/dd/yyyyy")

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

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