Below are some of the top new features of SSIS 2008
- Create Script tasks by using Microsoft Visual C# and Microsoft Visual Basic .NET.
- Use ADO.NET for tasks as well as for source and destination components.
- Improve scalability with thread pooling and enhanced lookup transformations.
- Perform more functional and scalable data transfers with the improved SQL Server Import and Export Wizard.
- New SSIS connectors for SAP BW, Oracle and Teradata.