Parsing Problem

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  December 24, 2009 at 4:15 pm

  #156530

  I have this condition in my where clause

  CAST((SELECT SettingData FROM PropertySettings WHERE SettingName = 'BusinessDate') AS datetime) > '20091221'

  It parses fine and work as expected in SSMS. It also parses fine in SSIS OLEDB Data Source editor. BUT when I try to replace the hard coded date with an parameter marker (?) it fails the parser. So, this does NOT parse:

  CAST((SELECT SettingData FROM PropertySettings WHERE SettingName = 'BusinessDate') AS datetime) > ?

  I don't get it. Anybody have any ideas?

  Thanks And Merry Christmas!

  .

• wwei

  SSC Eights!

  Points: 961

  More actions

  December 26, 2009 at 10:02 am

  #1096532

  If you pass a DATE type parameter, it should work.

  For example, create a DateTime variable, and map it with DATE data type.