MyDoggieJessie (2/10/2014)
Of course, you make valid points - 😉 I originally suggested SSIS, but provided a TSQL alternative - not pretty, but there it is...
The use of xp_CmdShell shouldn't be a problem for anyone if it's done correctly and it's pretty easy to do correctly especially security wise.
--Jeff Moden
Change is inevitable... Change for the better is not.