I am pretty sure the SoSS has nothing relating to Scott except in print - I've trawled for c.1800 tune sources pretty thoroughly. Not much more in the University of Edinburgh special collections department. The NLS is your best bet.

It would help to know exactly what you're hoping to find. If you're after manuscripts of the Minstrelsy with notation for the tunes, be assured they don't exist and never did.