Hello Experts Exchange
I need to develop a SSIS package that will update a table if a record exists, if a record does not exist then insert the record.
However if a record does exits and only update the record if the field Verified is null and the field Populated = Y.
I think I need to use a Foreach Loop Container to be able to do this check on each record, but I don't know how to configure.
How would I configure the SSIS package to do this?