Hi,

Please someone help me on this issue. I'm trying to migrate from DTS to SSIS using the Migration wizard i'm getting the following error.

"Index was out of range. Must be non-negative and less than the size of the collection... Its quite urgent. Please do the needful.

Also i cannot open the DTS Package in SQLSERVER 2005, throws error "SQL Server 2000 Designer components are required to Edit DTS Packages... Is it because of that not allowing to migrate to 2005.

Thanks,
Chandra

__________________
Thanks,
Chandra

This is the problem not related to leading spaces, trailing spaces, or any characters that are invalid.
I tried but not working.

Thanks,
Chandra

It got worked out, it because of the leading spaces, trailing spaces or any invalid chars for all packages in the server. I corrected the other packages info. by using the query
SELECT DISTINCT name
FROM msdb.dbo.sysdtspackages
WHERE name LIKE '% '


Thanks,
Chandra

Everybody know that DTS to SSIS Migration is very tedious and manual approach is very time consuming.

I would recommend you to try 3rd party product called DTS xChange. The liked this product very much because... its full Migration package including Discovery, Conversion and Auditing of packages when you run them after migration. It will apply best practices while migrating your packages so if are new to SSIS then this tool will save you significant amount of time.


here is the link

www.dtsxchange.com

Screenshots
http://www.dtsxchange.com/dtsxchange_screenshots.asp