DTS parameter problem w/sybase

• franciscotheman

  SSC Veteran

  Points: 246

  More actions

  October 21, 2002 at 11:10 am

  #158211

  Hello--

  I want to use a parameterized sql query as a record source for a dts routine. The data source is a sybase sqlanywhere 5.0 database. A simplified example of the problem follows:

  select "Agency_Tbl"."Agency_Name_Ch"

  from "Agency_Tbl"

  where "Agency_Name_Ch" = ?

  This doesn't work when I have defined and filled a global variable. I get the error: "[Sybase][ODBC Driver]Wrong Number of Parameters" (A ss2000 to ss2000 import does work with this syntax). The following hard code does return results:

  select "Agency_Tbl"."Agency_Name_Ch"

  from "Agency_Tbl"

  where "Agency_Name_Ch" = 'Agency2'

  Any help would be greatly appreciated.

  --Greg

  Edited by - franciscotheman on 10/21/2002 11:20:21 AM

  Edited by - franciscotheman on 10/21/2002 11:21:18 AM

  Edited by - franciscotheman on 10/21/2002 11:23:01 AM

• October 28, 2002 at 6:31 pm

  This was removed by the editor as SPAM