dbTalk Databases Forums  

Sybase stored procedure-parameters not recognised

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Sybase stored procedure-parameters not recognised in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rachel Jones
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.