I am trying to use the package migration wizard to transfer a package
from Sql Server 2000 (DTS) to Sql Server 2005 and I get the following
error no matter what I do/change. Any help would be great.


This wizard will close because it encountered the following error:
(Microsoft SQL Server)


------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdN...+Visual+Studio...



===================================


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.UniquePackagewithCurrentVers ion(PackageInfoCollection

m_pInfoCol)
at WizardUI.ListPackages.OnEnterPage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
sender, EventArgs e)

Did you find a solution for this? I'm having the same issue.

I am getting the same error. Did you find a solution?
Al

"Allen" <amodine (AT) hotmail (DOT) com> wrote

I wonder how many people have to mention the same problem before MS
people respond ... I have the same one.

Allen wrote:

It looks like this was an error originating in ADO.Net 1.1 and it had a
hotfix for it:
http://support.microsoft.com/default...b;en-us;836874

But we are running .Net 2.0 now

Please help!

Koni Kogan wrote:

Koni Kogan wrote:

name that has it. Use the following query to identify them:

select name +'zzz' from msdb.dbo.sysdtspackages where name like '% '

It should work once ALL packages have been renamed - just an MS feature;-)