Posted by: Denny Cherry
BIDS, Integration Services 2008, SQL Server 2008, SSIS
If you are like me and don’t know anything about C#, and you don’t want to have to change the script language every time to create a .NET script from C#.NET to VB.NET you can change the default.
Open BIDS, and select Tools > Options. On the menu on the left select “Business Intelligence Designers” then “Integration Services Designers”. In the Script box in the middle of the right pain change the option in the drop down from “Microsoft Visual C# 2008″ to “Microsoft Visual Basic 2008″.
If you prefer C# you’ve got nothing to worry about as C# is the default option.