You don't always need to use C# scripting tasks, especially not for reporting tools. About the only time I've used it is for calling web services. If you already know SSIS or SSRS, then you've probably already learned it's own expression language, so picking up a little C# is not that big of a deal. There are plenty of examples covering specific tasks that can be Googled. Actually, I would say that the best BI professionals I've ever met had no background in application programming; they were just smart subject matter experts who knew how to use BI tools and who picked up enough scripting along the way to get by.