You ask an uncertain question. It is hard to make suggestions without further details. If you expect answer as: "Yes, CLR is really good stuff!" then you probably couldn't get it here.It looks like some kind of survey which is not in the right place. CLR is good for some tasks, and poorly applicable for others.
As alternative one might use SSIS simply to deal with csv, not the CLR stored procedures. But if you plan to make any complex calculation or strings manipulation you should use CLR.
Try refer
this link[
^] for details.