Problems with STP stage
Posted: Tue Apr 01, 2008 3:34 pm
Friends,
I was trying to use STP stage, for the first time, to execute the stored procedure. The design of the job is simple: it executes a procedure without any input parameters
STP stage properties
Stored Procedure Name: PROMOTION_DIM.MAIN_PROCESS
Generate Procedure Call: NO
Procedure Type: Source
Stored Procedure Statement: BEGIN PROMOTION_DIM.MAIN_PROCESS(); END;
The job compiles without errors/warnings but when I try to execute the job it fails with the following error:
"Client Library property required for stage STP_STG.Stored_Procedure_41"
Can someone help me with this error?
Thanks in advance
Yamini
I was trying to use STP stage, for the first time, to execute the stored procedure. The design of the job is simple: it executes a procedure without any input parameters
STP stage properties
Stored Procedure Name: PROMOTION_DIM.MAIN_PROCESS
Generate Procedure Call: NO
Procedure Type: Source
Stored Procedure Statement: BEGIN PROMOTION_DIM.MAIN_PROCESS(); END;
The job compiles without errors/warnings but when I try to execute the job it fails with the following error:
"Client Library property required for stage STP_STG.Stored_Procedure_41"
Can someone help me with this error?
Thanks in advance
Yamini