In addition to adding more tables while editing a data source, you can also add or remove columns from loaded tables. This makes it easier to include new source columns with your job, edit the data source definition to add or remove columns, and adapt existing jobs to change source schemas.
This feature captures all relationships. The relationships are automatically created for you when you add a primary key column.
Do not edit the schema when altering tables.
To add/remove columns in a loaded table:
While viewing the Selected Tables section of the Select Tables step, expand one or more tables.
Click the checkboxes to select/deselect tables columns for import.
You cannot deselect all columns and tables in the job.
Click Next and complete the import.