Yes, you should, even if it is just being able to read it and understand what is happening. There are several languages I don't even have basic coding skills in but I can read them and get 98% of what is happening, the other 2% is the nuances, which a good coder should have noted in comments.

It never hurts to know it. For SSIS there are some things that are not easily accomplished with the available tools and in general I don't like to use 3rd-party tools unless they are really necessary. I absolutely want to be able to read any SQLCLR code that comes my way, if for no other reason to quiz my developers why they didn't use T-SQL for this or that function..

CEWII