I have a txt file from a client with the structure: Column A, Column B, Column C. The table I want to import this to has an ID column set to primary key. SQL Server generates a new id when a row is added. So my table structure looks like: ID, Column A, Column B, Column C.
There is no ID column or data in the source file, so is it possible to not map this column and ignore it before importing a file? At the moment when I try to Process the import the summary page returns the High level warning "Primary key "ID" is not mapped".
