I am not sure if BCP can do this, or anything in SQL server can do this.

I am trying to take a file that contains several record types: RHDR, RDET,
RCOM.

When the record type (position 1-4 in my input file) is RHDR, I want to
insert into certain columns in TEMP_TABLE.

When position 1-4 is RDET, I insert into different columns in TEMP_TABLE (or
perhaps a different table).

This is conditional inserts using SQLLDR in Oracle. I haven't been able to
find that same funtionality in SQL Server. Anyone point me to the correct
terminology to be searching for?