Ryan Keast (1/3/2014)
Theses are the errors I receive after I run the SSIS after creating a second field in the database which is the primary key.The field I have created is an INT called UniqueID. I thought it would automatically create a number? It is not mapped to anything from my txt file.
You've added a column with a data type of INT, but it won't auto-populate - you can't do that from a flat file. If you create your destination table with an additonal column of type INT with the IDENTITY(1,1) property though, each row that you insert into the table will have a unique integer value courtesy of that column.
Regards
Lempster