Yes - just install Visual Studio (same version as used by BIDS - this changes depending on the version of SQL Server you are using) and include C# as part of that installation and your pretty much done. Then you can open an existing BIDS solution/project and add a C# project to it.