SSIS Data Flow Soft Date Experssion

• Don J

  Newbie

  Points: 3

  More actions

  March 20, 2008 at 11:44 am

  #122716

  Using SSIS Data Flow I successfully run the following code.

  ("DS_Trouble_Ticket"."RD-CD">={ts '2008-03-16 00:00:00'} AND "DS_Trouble_Ticket"."RD-CD"< {ts '2008-03-17 00:00:00'} )

  I need to soft code the dates with the equivalent of "Today" or "Today -1"

  I have tried GetDate and SysDate and many combinations but they all fail.

  Frustrated...I would appreciate any suggestions.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 21, 2008 at 10:16 am

  #792585

  According to SSIS help the correct function is GetDate() so this should work:

  ("DS_Trouble_Ticket"."RD-CD">=GetDate() AND "DS_Trouble_Ticket"."RD-CD"< DateAdd(DD, -1, GetDate() )

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question