Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

package migration wizard

0 views
Skip to first unread message

Allen

unread,
Nov 16, 2005, 2:40:13 PM11/16/05
to
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?ProdName=Microsoft%u00ae+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.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)

jud...@gmail.com

unread,
Nov 28, 2005, 5:56:45 PM11/28/05
to
Did you find a solution for this? I'm having the same issue.

Al Cadalzo

unread,
Dec 17, 2005, 7:33:56 AM12/17/05
to
I am getting the same error. Did you find a solution?
Al

"Allen" <amo...@hotmail.com> wrote in message
news:1132170013....@g49g2000cwa.googlegroups.com...

Koni Kogan

unread,
Dec 21, 2005, 4:49:18 PM12/21/05
to Allen
I wonder how many people have to mention the same problem before MS
people respond ... I have the same one.

Koni Kogan

unread,
Dec 21, 2005, 5:29:01 PM12/21/05
to Koni Kogan, Allen
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.aspx?scid=kb;en-us;836874

But we are running .Net 2.0 now

Please help!

Koni Kogan

unread,
Dec 21, 2005, 6:17:09 PM12/21/05
to Koni Kogan, Allen
Koni Kogan 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.aspx?scid=kb;en-us;836874
>
> But we are running .Net 2.0 now
>
> Please help!
>
> Koni Kogan wrote:
>
>> I wonder how many people have to mention the same problem before MS
>> people respond ... I have the same one.
>>
>> Allen wrote:
>>
>>> 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)
>>>
>>
>>
>>>
>> ------------------------------

Ok, here is the deal: remove the trailing space from ANY dts package
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;-)

0 new messages