3

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?

KyleMit
  • 30,350
  • 66
  • 462
  • 664
QuachNguyen
  • 131
  • 11

1 Answers1

4

  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.

KyleMit
  • 30,350
  • 66
  • 462
  • 664
  • I installed SP4 and that fixed the Design Script button http://www.microsoft.com/en-us/download/details.aspx?id=7218 – Alex Oct 28 '14 at 14:39