I have attached the execution plan in here. The DTC_BI_DM_SOH table does not have any index. It is a temporary table and all the time truncate and reload happens over this....

Hello Phil,

I have removed the SQL command from the expression instead used just a value. Now it works.

Hello Phil
I am using OLEDB.  StoreNo variable is declared as String.

The below screenshot is from config table. 

One thing I have noticed is all the columns from snowflake are shown as Text data type in ODBC source. Earlier I used data conversion to change into respective data...

Thank you, Thom. My guess was correct. 🙂

Hi Phil, 

It's already redirected.  But now they want to do this on the go.  They want to remove look up and use script component and identify the miss...

Yeah , it worked. I also adjusted the interval of the data label. Thank you, Anthony.