SqlCLR, Ole Automation, ssis usage in and of itself is not insecure in my opinion, even loading and using an http stack. These tools are very useful provided certain limits...

It has long been best practice to firewall databases from the internet. Both SSIS and SqlCLR are proscribed by most corporate governance practices from internet connections altogether, proxies block outbound...