The original file (delimited text) that I am reading has 6 fields to make up a single record. I have mapped the records all using the transformer to the appropriate MS SQL table. There however is a 7th field in the record which isn't part of the intial text file, which we use for grouping together the data (resort_id). This field usually contains an integer (in this case, the integer will be 1). How do I write that integer to each record along with the other fields that are already part of the record. What I need to do is create a field value to go into the MSSQL record.

Frank

You may use Literal _object_ for it.

Add Literal _object_ to the transformation
Double click on it and enter the value you would like to use
Connect Literal to target field

John