Another option or variation on the solutions offered would be to parse the string using CLR ?

We have gone down this route before and, without digging up the benchmarking(sorry), we found it quicker on CPU.

Further if the list of variables were fixed, such as int (ie- 4byte), our data can be sent using the varbinary(max) datatype and split (again using CLR).

Just some ideas... 🙂