To perform a full load with Data Axcess Utility, do the following:

Option 1.

1. Open Data Axcess Utility Manager.
2. Navigate to job history.
3. Select Full Update for the applicable tables as follows (Tip: If you need a full update on all tables, this technique may be easier.)
   1. In the upper left corner, use the drop-down to show 100 entries.
   2. Click on the first Full Update checkbox.
   3. Press the Space key.
   4. Press the Tab key twice.
   5. Repeat Space and Tab key combinations until all tables are selected.
4. Re-run the scheduled task: CCHDailyDataPull.

  Option 2.

1. Run the query below in SQL Management Studio to check all the Full Update checkboxes.
2.  Re-run the scheduled task: CCHDailyDataPull.

UPDATE [DW_RAW_CTL].[dbo].CTL_CDC
SET TRUNCATE_ON_NEXT_LOAD       = 'Y'
  ,  NEXT_LOAD_IS_FULL_LOAD_FLAG = 'Y'
WHERE PERMITS_FULL_LOAD_FLAG = 'Y'
GO