I have a job in which stored procedure will be called and output of stored proc will be sent to further process.
Stored Proc will take 2 arguments as input and provides the output in 2 arguments.
Input arg : startdate and enddate
Output are : ABC and XYZ.
Please let me know which stage (STP or ODBC) to use to call sql server stored procedure.
Thanks in Advance
Sqlserver Stored Procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Mar 20, 2008 11:55 am
use stored procedure stage
Use Stored Procedure stage and you have a option for SQL Server as one of the vendors, Try it...
Since your requirement has both input and output you cannot use ODBC stage.
Follow this Link
Since your requirement has both input and output you cannot use ODBC stage.
Follow this Link
Thanks.
"Creativity is the ability to use your available resources to their fullest."
"Creativity is the ability to use your available resources to their fullest."
I've been having tonnes of issues with it too. Passing parameters to a stored proc seems to be a no go for me using the Stored Procedure stage. As well, sometimes the ODBC Enterprise stage works fine for me and sometimes it can't see the field names. Bizarre. And other times both the ODBC Enterprise stage AND the Stored Procedure stage fail.snt_ds wrote:We are using STP stage but we are having problem while selecting multiple records as output. Its working fine for a single record output.
Thanks in Advance
Data Direct, on their web site, claim their most recent version supports SQL Server 2005, but I wonder if the version that is included with Datastage has some issues with SQL Server 2005.