Home Forums SQL Server 2005 T-SQL (SS2K5) where date1 > ? AND date2 <= GETDATE() does not work in yukon RE: where date1 > ? AND date2 <= GETDATE() does not work in yukon

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