Post reply

where date1 > ? AND date2 <= GETDATE() does not work in yukon

  • March 9, 2007 at 4:06 am

    #194485

    hi. the where condition in a dts package is as follows:

    where date1 > ? AND date2 <= GETDATE()

     

    The qustion sign wont work in sql server 2005 query window. what is the modern day equivalent of this?

  • March 9, 2007 at 7:13 am

    #694081

    Just put in the date and time you want to start with:

    where date1 > '20070308 02:45:00.000' AND date2 <= GETDATE()

  • March 9, 2007 at 7:31 am

    #694085

    i dont know what date or time should be there though! there is a ? sign, and i dont know what date time that represents in sql server 2000

  • March 9, 2007 at 8:43 am

    #694116

    The '?' is a parameter placeholder. In Sql2K DTS, it would typically be replaced at runtime by a DTSGlobalVariable, presumably so that the DTS package could be dynamically run for different date/time periods.

    Is this still a DTS package running under SQL2K5, or has the package migrated to SSIS ?

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

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