The Fiddlers Companion has extensive information:

http://www.ibiblio.org/fiddlers/SO_SOR.htm

The tune seems to be found everywhere, but where it actually originated still appears to be obscure. That's folk music for you. However it's probably European rather than American.