Hi All, variables values are not populated in the query from config table when iam executing the package.If i print StartDate,EndDate vaiables individually iam getting the values of config table. The below one is my query. "SELECT ITEM_CHRVAL.ISO_CNTRY_CODE AS ISO_CNTRY_CODE,ITEM_CHRVAL.ITEM_CODE AS ITEM_CODE,ITEM_CHRVAL.CHR_CODE AS CHR_CODE,ITEM_CHRVAL.CHR_VAL_CODE AS CHR_VAL_CODE,ITEM_CHRVAL.CRT_DTTM AS CRT_DTTM,ITEM_CHRVAL.UPD_DTTM AS UPD_DTTM,ITEM_CHRVAL.DEL_IND AS DEL_IND,XCD.XCD_ID AS XCD_ID FROM ITEM_CHR_VAL_V ITEM_CHRVAL,XCD_V XCD WHERE ITEM_CHRVAL.ITEM_CODE = XCD.ITEM_CODE AND (ITEM_CHRVAL.UPD_DTTM >to_date('"+ @[User::StartDate] +"','dd/mm/yyyy hh24:MI:ss') AND ITEM_CHRVAL.UPD_DTTM<=to_date('"+ @[User::EndDate] +"','dd/mm/yyyy hh24:MI:ss'))" Could you please any one of you help me in this query if i did any mistake while concatening. Thanks & Regards, Anil

What values you are getting for those variables ?? try to print the query using and see did you set "EvaluateAsExpression" property to true for the variable which hold this query.Shailesh, Please mark the post as answered if it answers your question.

Hi Shailesh, Thank you so much for your answer. I have checked and set "EvaluateAsExpression" property to true. Its working fine now. Thanks for your valuble info. Thanks & Regards, Anil

What values you are getting for those variables ?? try to print the query using and see did you set "EvaluateAsExpression" property to true for the variable which hold this query.Shailesh, Please mark the post as answered if it answers your question.