Set extraction options

  1. On the Data Source tab, expand the tree view to locate the object.
  2. Right-click the source object and select Detailed Properties > Processing Options > Extraction.
  3. Set the extraction options and click Refresh SQL.
    Extraction options Description
    Full Extraction All table rows will be extracted from the data source system (depending on filter definitions).
    Extract Modified Rows Since Last Extraction The most recent modified date, the date when data was last extracted, will be stored in the DWD repository. The incremental filter definition is regenerated after every extraction.
    Extract a Date Interval All table rows with a modified date that is between the start date and the end date will be extracted. The SSIS package is not regenerated.
    Extract Last Days Changes The profile only extracts the table rows that were modified in the last x days.
  4. Click Apply > OK to set the options.