Job parameter question
Posted: Fri Nov 12, 2004 2:02 pm
I have the following DS job design. DRS stage type is used for reading and writing data between the Source and the Target
Source--------->Transformer-------------Target
Parameter BUSINESS_DATE (DATE) is passed as date to the job and is being used in the transformer to map to a target column EFFECTIVE_DATE (DATE).
I have the folowing code in the job control window of the job.
BusinessDay=Oconv(( @DATE ) , "D-YMD[4,2,2]")
ParamName = "BUSINESS_DATE"
ParamValue = BusinessDay
ErrCode = DSSetParam(hJob, ParamName, ParamValue)
The parameter value is not getting changed dynamically, the job still uses the default value of the BUSINESS_DATE parameter, which is a dummy date(01-01-1900).
Any help is appreciated
Source--------->Transformer-------------Target
Parameter BUSINESS_DATE (DATE) is passed as date to the job and is being used in the transformer to map to a target column EFFECTIVE_DATE (DATE).
I have the folowing code in the job control window of the job.
BusinessDay=Oconv(( @DATE ) , "D-YMD[4,2,2]")
ParamName = "BUSINESS_DATE"
ParamValue = BusinessDay
ErrCode = DSSetParam(hJob, ParamName, ParamValue)
The parameter value is not getting changed dynamically, the job still uses the default value of the BUSINESS_DATE parameter, which is a dummy date(01-01-1900).
Any help is appreciated