we have an ssis packa created in such a way that

Data will loaded into the DAT_STAGE from Flat file and then we need to insert that values from Dat_stage to Dat_DES.

Daily this SSIS job will run and data will in to the table.

we have created a step in the JOb in such way From DAT_STAGE values should insert into the DAT_DES with out duplicate values with the above query which mention.

But it is not working........

can any one give me an idea....

Thank you very much for reply......

Many thanks..........