Hi.
I'm having a problem with migrate a dts package to ssis. The migration step
fails with this message:
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)

This message comes when it's time to select a package.
Any help would be appreciated.

Thanks,
Carl

I had the same problem. I just found this:

http://sqljunkies.com/WebLog/joesack.../03/17743.aspx

I'll copy the text in case the link ever goes away:

SSIS BUG - Migrate DTS 2000 Package fails when pulling packages with
trailing blanks
So today I was testing out the SSIS "Migrate DTS 2000 Package" wizard. I
went through the following steps:

1. In BIDS, I right-clicked the SSIS Packages folder in the Solution
Explorer.

2. Selected Next at the Wizard intro.

3. Selected the source location (where I'll be pulling the packages from).

4. Selected the destination location (the folder where the converted
packages will reside).

On the next dialog box I'm supposed to see a list of DTS 2000 packages on
the source SQL Server instance, but instead I get the error:

"Index was out of range. Must be non-negative and less than the size of the
collection.

Parameter name: index (mscorlib)"

After digging through the newsgroups, I found a tip that this was caused by
trailing blanks in the DTS package names. I ran the following query to
identify the offending packages:

SELECT DISTINCT name
FROM msdb.dbo.sysdtspackages
WHERE name LIKE '% '

After renaming the packages (removing trailing blanks) - the List Packages
dialog box worked! Thanks Koni Kogan!



"Carl" wrote:

Hello Michael.

Thanks for your help, it solved the problem.

Regards Carl

"Michael" wrote: