Script Editor won't open or change language in SSIS 2005

Question

I have a task which creates a SSIS package using BIDS 2005. There are 2 problems when I work with BIDS 2005, but don't occur in BIDS 2008.

1. Default language in Script Editor is Visual Basic (I prefer C#).
2. When I click on the Design Script button, it closes current Script Task Editor and nothing happens.

My personal ideas are:

1. SSIS 2005 doesn't support C# version to write custom code
2. Bug in BIDS

Any suggestions?

Answer 1

1. SSIS 2005 only supports VB.NET (not C#) within Script Task or Script Component.

2. Make sure that you have Microsoft SQL Server 2005 Service Pack 3 installed on the machine that has BIDS. If not, download Service Pack 3 here and install it.