Upgrading Your SQL 2000 DTS Packages
Many folks are still in the planning stages of their SQL Server 2000 to SQL Server 2005 upgrade. While there are a bunch of benefits to using SQL Server 2005 (see performance gains on SharePoint usage as one example), the upgrade requires careful analysis. One area that has been especially complex is DTS packages. What do you do with them? How can they be upgraded? Will DTS packages be supported?
Brian Knight (http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp) wrote a very good article that answers the questions above. DTS packages are a great tool in the Business Intelligence toolbag. They help make the system “real” by bringing in the data from external systems and populating the dashboard repository. SQL Server 2005 has SSIS (SQL Server Integration Services). It's bigger, better and more powerful! The first step is getting there... Check out Brian's article for some nice tips.