Of course, you make valid points - 😉 I originally suggested SSIS, but provided a TSQL alternative - not pretty, but there it is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience