When you create a Data Source in SQL Server Integration services (SSIS), there are default Data provider will be listings in the connection manager dialog window.
In 2008, some new providers are added, upgraded and removed.
Have a look at the exhibit,
Blue Box – Newly added Data Providers in SSIS 2008
Magenta Box – Upgraded Data Providers in SSIS 2008
Red Box – Removed Data Providers in SSIS 2008
SSIS 2008 - Data Provider List
SSIS 2005 - Data Provider List