I am using the XML format file below to perform a Bulk Insert on data from a flat file. I need to map one of the source fields from the file to multiple columns in the table. I tried to map the <Field ID> value 4 to multiple <Column Source>. I get the following error when I execute the Bulk Insert statment: "Msg 4874, Level 16, State 1, Line 1
Line 28 in format file "\\it-dev1\exchange\apply\format.xml": duplicate element id reference "4". Is there a way to map a value from a <Field ID> attrribute to multiple <Column Source> attributes.