This issue which i have posted is discussed many times in forum and i have applied some suggestion,but it seems it does not work for me.
I have a sequence which running a job(Multiple Instence) from where i get the BATCH_ID,and i am passing valune of batch_id as parpameter to rest of downstream jobs in a sequence.For this i am calling server routine in Basic transforme GetUserStatus which calling the functions DSSetUserStatus.
While passing userstatus to parameter,i am writing below code:-
Code: Select all
P_BATCHID=Trim(Convert(@FM,"",Sp_Gen_Seq_Num_Job.$UserStatus))
Code: Select all
Exception raised: @Main_Job, Error calling DSSetParam(P_BATCHID), code=-4 [ParamValue/Limitvalue is not appropriate]
Can someone help me to resolve this issue.