BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package (917420)


The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
Bug #: 415806 (SQLBUDT)

SYMPTOMS

Consider the following scenario. You use the Package Migration Wizard to migrate a Data Transformation Services 2000 (DTS) package in Microsoft SQL Server 2005. The Package Migration Wizard tries to list the packages on the source server. In this scenario, you receive an error message that resembles the following:
This wizard will close because it encountered the following error: (Microsoft SQL Server)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00& EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR& EvtID=UncaughtException&LinkId=20476
===================================
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib)
------------------------------
Program Location: at System.Collections.ArrayList.get_Item(Int32 index)
at WizardUI.ListPackages.UniquePackagewithCurrentVersion(PackageInfoCollection m_pInfoCol)
at WizardUI.ListPackages.OnEnterPage(EventArgs e) at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

CAUSE

This problem occurs when one of the following conditions is true:
  • The name of the DTS package starts with a space.
  • The name of the DTS package ends with a space.
  • The name of the DTS package contains a character that is invalid in SQL Server 2005 Integration Services (SSIS).

WORKAROUND

To work around this problem, rename the DTS package so that the name does not include leading spaces, trailing spaces, or any characters that are invalid.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:8/25/2006
Keywords:kbtshoot kbbug KB917420 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.