I am importing data from Flat file using SSIS. I created a table named: _Vendors with the following column name:
[Vendor_Id], [Name1], [Vendor_Status], [Vendor_Persistence], [Vendor_Class], [WTHD_SQ]
When ever i load data daily if the vendor_id is different insert. If vendor_Id is same but the Vendor_Status is changed update. Is there a way to tackle this.