Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: Inputing dates in DTS package

    I'm trying to import a file that's a bit old, and I only want to worry about things if they happened past a certain date (8/29). I've got an activex script using an input box to put in the date that is to be used and a global variable set up to take the input, but where do I go from there to incorporate it into a SQL task in a DTS package? More or less I want to do my checking if the record date is less than the input date. Please help.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    You can incorporate the global parameter in the task by using ? and mapping it to the global parameter but I prefer to use an activex script to set the source of the transfer before it runs.

    See
    http://www.nigelrivett.net/SetDTSRunTimeValues.html
    for the sort of thing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •