There are no duplicate values in the staging table ....

SSIS job is created in such a way that after inserting the Values to DAT_DES form DAT_STAGE we will delete the data present on the DAT_STAGE table.....

Next day when the ssis job runs the fresh data will load into the DAT_Stage....from Flat file...

Some times this data will contain the same values...i.e values that are present on DAT_DES.......

So we need to insert only those values which does not contain on DAT_DES.....

Many THanks,