You could create a DTS package to do this or you could write a script. Either way, there is no automatic table split.