We have 3 - 4 Desktop / Windows Application which has MS Access Database.
This MS Access database has couple of tables like Members, Insurance etc ..!
Through SSIS Package, i am trying to import values from MS Access to SQL Database which is located on Main Server.
Issue :- Tables like Members, Insurance from MS Access while importing to SQL - They have PrimaryKey / identity column for MemberId field, InsuranceId..!
How should i import values from MS Access to SQL Tables which has identity/PrimaryKey columns?