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

  • 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?

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

    where date1 > '20070308 02:45:00.000' AND date2 <= GETDATE() 
  • 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

  • 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