Help and Support
 

powered byLive Search

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

View products that this article applies to.
Article ID:917420
Last Review:November 20, 2007
Revision:2.2
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)

Back to the top

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).

Back to the top

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.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

Back to the top

APPLIES TO
•Microsoft SQL Server 2005 Standard Edition
•Microsoft SQL Server 2005 Standard X64 Edition
•Microsoft 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

Back to the top

Keywords: 
kbtshoot kbbug KB917420

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.