Sybase stored procedure-parameters not recognised -
07-13-2004
, 08:17 AM
I have a package where I want to execute a Sybase stored
procedure (using ExecuteSQLTask), then pick up the output
value and pass it to an ActiveXScriptTask; however, when I
click on the parameters button it always tells me that
there are no parameters in the SQL statement, when there
patently are (about 7 input parameters), so I cannot get
to the output parameters screen.
Is this because parameters just aren't supported for
Sybase stored procedures? I am using SQL Server 2000 with
Sybase 12.5.
Does anyone have an alternative way of getting the return
value from the stored procedure please?
Thank you
Rachel |