I was trying to migrate DTS packages from SQL Server 2000 using Package
Migration Wizard of SQL Server 2005 and successfully migrated 27 of them.
When I tried the 28th DTS package, I got the following error message. From
then on, I could not migrate any more DTS packages even from the same SQL
2000 Server. Can anyone help me on this problem? Thanks in advance for your
help:

Index was out of range. Must be non-negative and less than the size of the
collection. Parameter Name: Index(mscorlib)

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!



"Bong Kim" wrote: