Hi,

We get the following error dialog box when we try to migrate SQL2000 DTS
packages from an SQL2005 server.

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

Any ideas why this is happening?

Thanks

Chris

I have seen in the past that this is caused by trailing blanks in your DTS
packages names.

run this script to
identify the offending packages:

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


Rename the packages (removing trailing blanks)



Re run the wizard and see if that helps.



thanks,



--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Chris Wood" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thank you Warren. We had one package with a trailing blank.

Chris

"Warren Brunk" <wbrunk (AT) techintsolutions (DOT) com> wrote