I guess i found the problem..

it because of the RTM version i am using that has a bug in Bypassprepare. see page below.

http://killspid.blogspot.com/2007/01/ssis-bypassprepare.html

i remove all the codes and change the code to only

exec(?)

if came back with the same syntax error, i guess something to do with the parameter passing.

It works properly in...

my resultset was set to single row.

my query was set,

it return 0 when no result, and return 1 if there is result.

i even try to run in on the server...