If you know Java well, C# is the obvious choice.
You can do the same things in a script task/components with C# or Visual Basic, so it all boils down to personal choice.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP