SSIS script component supports C# as well as VB scripting.. If you are comfortable with VB , you can use that..
Script component in most cases involves 2-3 standard methods ( Input0_ProcessInput ,Input0_ProcessInputRow CreateNewOutputRows etc) , so if you know C# syntax, that will do..
Below is a post for creating sample script component using C#