posted on Tuesday, January 03, 2006 11:13 AM
by
joe.sack
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!