I need to do an import where one of the cols isnt in the source file but for a given import, its the same value. I'm "unflatening" a file into related tables and for some fo the columns, I need to basically rotate the data such that the values go into one col and the "typeID" is related to the original col it come from so defaulting the tgt table isnt an answer as mentioned in http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21735262.html
. I truely want to hardcode a value into the format file. Otherwise I need to do some intermediate work in one or more working tbls. I'd like to skip that step if possible. Possible?