DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

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

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf