Hi Gurus, I have included 2 new columns to existing 2 tables. But data for these new columns showing NULL values in PROD. No data loading for newly added columns in PROD but fine in UAT. Please help how to reslove this issue.

Hi, verify the mapping between these 2 columns(src to destination) and check that data is available in source(for these two columns) from your Production environment. thanks, Zaim Raza.

Hi Zaim Raza, Thanks for the reply. It is working fine in UAT but not working in PROD. I will veify PROD data. Any other solution please.

Hi, Data folow transformation is very obvious.i reckon it's due to the source data problem if mapping is perfect. please let me know once you verify the prod data. cheers, Zaim Raza.

Hi Zaim Raza, I have verified SSIS package. New columns have not mapped to destination table and sequences are failed. PROD team update the tables with the new columns. Issue is fixed. Thanks for the time and suggestion.