SQL Server Integration Services (SSIS) 2008/2008 R2 includes a number of component, data management and performance enhancements. This topic briefly outlines these enhancements. For more information in Books Online, see What's New (Integration Services). For an audio podcast, see What's New in SQL Server Integration Services 2008.
- Performance enhancements to the Lookup transformation include faster cache loading and more efficient lookup operations.
- The new ADO.Net source component consumes data from a .NET Framework provider and makes the data available to the data flow.
- You can configure the ADO.Net source component to use the use the System.Data.SqlClient.SqlBulkCopy interface to improve the performance of bulk insert operations.
- The new ADO.Net destination component loads data into a variety of ADO.NET-compliant databases that use a database table or view.
- Profile data that is stored in SQL Server using the new Data Profiling task. The information provided by the profile helps you identify potential problems with data quality.
- Use the Integration Services Connections Project Wizard to create a package that contains the connection information that you need to connect data sources and destinations.
- Write scripts in both Microsoft Visual Basic 2008 and Microsoft Visual C# 2008, using the Microsoft Visual Studio Tools for Application (VSTA) environment. VSTA also enables you to add a Web reference in your code that enables the code to use objects and methods provided by a Web service.
- When you use the dtexec command prompt utility (dtexec.exe) to run a deployed package, Integration Services now applies package configurations applied twice.
- The SQL Server Import and Export Wizard now provides additional information and options related to the date type conversions that the import or export operation requires.
- New date and time data types support a larger scale for fractional seconds, user-defined precision, and time zone offset.
- The SQL statement in an Execute SQL task can contain a MERGE statement.
- Integration Services can use a new Database Engine feature called change data capture.
- You can create debug dump files (.mdmp and .tmp) that provide information about what happens when a package runs.