More stupid questions from me. It takes a lot of effort being this dumb.

So I have a text file and I have worked out to strip the Trailer at the end of the file by using a conditional split. I've also worked out how to get rid of the "" that were surrounding my text as they were importing in my database as well.

At present my database only has one filed in it called "RecordIdentifier" it's a Varchar(3) as I try and get my head around trying to fully import he text file I have.

My Flat File connection manager editor I have renamed "Column 0" and renamed it to "RecordIdentifier" in order to match to the database field of the same name.

Now it is a DataType of String[DT_STR] and an output column width of 5. (3 + the 2 double " marks)

What I want to do is how do I create an ID that will be unique and auto create when I import "at present" my one column of data. I have about 80 odd fields in the text file and want each row to have a unique number.