Upgradation of SQL 2000 to SQL 2008 on Windows Server 2003

[vamsimadineni]

I am looking to migrate the SQL 2000 applications to SQL Server 2008
and the OS will be Windows 2003 Server.
Please let me know whether all the features will work perfectly or not?

the server where we run a lot of DTS's. I understand that SQL 2008
requires some add-ons to be downloaded and installed to make DTS's
work.

Can you please let me know which type of add-ons I need to download it?

Thanks in advance,
Vamsi.

[JAMES_911]

To upgrade to SQL Server 2008 R2

1.Insert the SQL Server installation media, and from the root folder, double-click Setup.exe. To install from a network share, move to the root folder on the share, and then double-click Setup.exe. If the Microsoft SQL Server 2008 R2 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to exit SQL Server 2008 R2 installation.

2.If the .NET Framework 3.5 SP1 installation dialog box appears, select the check box to accept the .NET Framework 3.5 SP1 License Agreement. Click Next. To exit the SQL Server 2008 R2 installation, click Cancel. When installation of .NET Framework 3.5 SP1 is complete, click Finish.

3.Windows Installer 4.5 is also required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart, and then run SQL Server 2008 R2 Setup.exe again.

4.When prerequisites are installed, the Installation Wizard starts the SQL Server Installation Center. To upgrade an existing instance of SQL Server, click Upgrade from SQL Server 2000, SQL Server 2005, or SQL Server 2008.

More information here.