Is it possible to only load Visits to existing SFs as part of a Bulk process?

Explanation

This can be done via the Bulk Replace tool. The following process queries Biotics to get a shapefile containing the fields required to do so. Using Esri's Append tool (Data Management), import the shapefile into the BulkReplaceTemplate.gdb. Populate the tbl_visits table with the Visit data.

Only data included in the data set will be written to the data records or overwrite existing data. Data within existing records will not be overwritten by NULL values in the Bulk Replace data set.

Solution

Attached are instructions to achieve the desired results, assuming that all the Source Features to update are pre-point spatial features. Should you have polygons or line features which need to be altered instead/as well, the attached query would need to be altered accordingly. If data is to be altered for many feature types (e.g., points and polygons and/or lines) then it would be more efficient to put them all in a geodatabase for using with the Bulk Replace too.