Karen Schaefer

Karen Schaefer

  • 2.1k
  • 17
  • 547

SSIS - Create a package- Check if record exists, if True then compare

Jan 17 2022 9:51 PM

I am attempting to create a SSIS package that will check and see if the record (ID) exists, if true then check for data changes from each field.  If change found then add new record, do not Update existing record.  If no changes found then conitinue, Then check if Record(ID) does not exists and insert  all new records.

How do I modify the SSIS package to compare existing record for data changes?  Which object do I use for the comparison?

Thanks,

Karen

 


Answers (1)