I could have. But it is not a Staging table. It is main table, acting as a main repositry.

Anyway I did make a partial solution for the problem.

We need to use 2 LookUp Transformations to get the desired result.

1 For collabarating data of the Flat file and the table that holds the partial data.

1 For checking for record existance based on the business key (i.e. ID (Primary Key))

Flat File Source --> LookUp (For collabaration) --> LookUp (For record check) --> OleDb Destination

The records that comes out in the (NO Match Output) are filled in the table.

I need to find out the way to update the records (Which come in the Match output)

If you guys can provide me a solution for it , it will be highly appreciated.