Thanks for all the assistance. I will give the OpenRowSet and try and hope it resolves the issues.

Correct, the customer could send the file the next date in the order of CustomerAddress, CustomerName, CustomerCity. The position of the columns names in the flat file could change...

Hey Jeff,

The client will send a flat file containing all the columns defined in the target table. For example, the target table will have 3 columns defined as such:...

Hello Jeff,

Unfortunately, I have do not have much control on what the client sends in the files, so the number of columns can change constantly. The Client can either...