Microsoft KB Archive/917420

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

Article ID: 917420

Article Last Modified on 11/20/2007

-

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

-



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 &quot;Applies to&quot; section.

Keywords: kbtshoot kbbug KB917420

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.