I am trying to add multiple values to a multiple metadata column via SQL using a third party migration tool (Layer 2), but it only works when I add one value as explained below.
I have written some testing code like this in SQL
Select … ,'Qualifications;BA' From
(Where Qualifications is the termset and BA and BSc are the terms)
And it works with just the one value with the SQL shown above.
However, I want this
To try to do this, I have amended the SQL like so
,'Qualifications;BA;BSC' ,'Qualifications;BA; Qualifications;Bsc ' ,'Qualifications;[BA];[BSC]'
But sharepoint does not attempt the format and wont add any values
The error I get back from the software is
Does anyone know what the SQL should be to make this work, if possible?