SQL import data when both source and destination has data and identity column
Don't just use the whole table. Instead choose the option to write a query.



Then simply write a select statement that doesn't use that Identity Column.


Alternatively, when you map columns, if you click "Delete rows in destination table", it will truncate the target table before loading data. If the opportunity exists for data to be removed from the source system and it should have remained in the destination, then this step will not be right for you.



Your package would look something like this