If I try adding an "id" to the schema coming out of my tMap and to the tMSSqlOutput schema, I get hit with a
"Identity column 'id' contains invalid INCREMENT." error. There's no where to specify an increment value in the schema editor!!! I can say the column is the key, I can say the DB type is INT IDENTITY, I can say the column is non-nullable, I can specifiy a length, precision, default, or comment...but no INCREMENT.
So then, if I go into my tMSSqlOutput component and check the "Specify identity field", logically I think that maybe if I specify the "Step" to be 1, that'll set the INCREMENT. Sounds like that should do the trick right? WRONG. I get another error. This time a "More than one column IDENTITY constraint specified for column 'id'". I never specified multiple identity columns. In the schema I said I wanted the "id" column to be my PK and an INT IDENTITY type. In the tMSSqlComponent I checked "Specify identity field", chose my "identity field" to be my "id" column, and set the step to 1. Where am I supposedly choosing more than one IDENTITY column?