Ideally DTS Packages should be upgraded to SSIS packages as we move from sql 2000 to sql 2005/sql 2008. And one of the good articles which provides information on how to upgrade DTS packages to SSIS package is written by Jason Howell
Microsoft blog to update sqlserver2000 dts to 2005/2008
Some one said that the issue with path :- Path issue
http://www.windows-tech.info/15/526346d6af32160c.php
or
Are you migrate or edit dts which is older version?
You have to installed this :-
http://www.microsoft.com/en-us/download/details.aspx?id=11988
or
http://social.msdn.microsoft.com/Forums/en-US/e372a9a7-a0b1-43e2-9bc7-b54bd8b252ab/sql-server-2000-dts-tools-web-download?forum=sqlintegrationservices
The reason are:-
- "You might need the 2000 runtime if you run this as a DTS package as well. I haven't worked with this in 2008, so I'm not sure, but 2005 had a runtime component as well."
http://www.sqlservercentral.com/Forums/Topic625890-148-1.aspx
- "However, if all instances of the SQL Server 2000 relational engine are removed or upgraded to SQL Server 2008 R2, the ability to develop DTS packages will no longer exist. The SQL Server 2008 R2 Setup application will install an updated DTS runtime and command-line tools, but no DTS design environment will be available. In this case, you can install the DTS Designer Components via a Web download as part of the Feature Pack for Microsoft SQL Server 2005 - December 2008. For more DTS-related upgrade information, see Considerations for Upgrading Data Transformation Services in SQL Server 2008 R2 Books Online.