Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 917420 - Last Review: November 20, 2007 - Revision: 2.3
BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package
Bug #: 415806 (SQLBUDT)
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)
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).
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.
Microsoft has confirmed that this is a bug in the Microsoft products that are
listed in the "Applies to" section.
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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate