DTS globel variable Date

• ajith.ranjan

  SSC-Addicted

  Points: 488

  More actions

  March 16, 2008 at 5:19 pm

  #121067

  I am trying to extract date from Sybase database via dts query my source connection is Sybase database via SQL anyware odbc driver when I run my query I get the following error

  Datasource =SELECT * FROM Sybase_table

  WHERE Sydate > ?

  Error:

  [Sybase][ODBC Driver][Adaptec server anywhere] Cannot convert 3/17/2008 10:03:03 AM to a timestamp

  Any help to resolve this will be much appreciated.

• GaSouthenU

  Say Hey Kid

  Points: 691

  More actions

  March 17, 2008 at 8:08 am

  #790352

  A Sybase datatype of timestamp is not actually a date/time datatype, it is really just a counter. You can't compare it to a date/time.

  http://www.sybase.com/detail?id=20316#X201581