You can also write C# code in your SSIS packages using the script task or script component. You don't need the full install of Visual Studio to do this, BIDS is enough.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP