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.