Ryan Keast (1/3/2014)
Sorry I don't follow - where do I set the IDENTITY(1,1)???
Presumably you are importing the data for your text file into a database table, yes? If so, when you create your destination database table, you need to add an extra column in the table definition, e.g.
CREATE TABLE [dbo].[MyTable] (
ID int IDENTITY(1,1) NOT NULL,
FirstColFromTextFile .......,
SecondColFromTextFile......,
....
....
)
Does that help?
Regards
Lempster