With SQL Server abandoning OleDB in favor of ODBC, it is no surprise that SQL Server Integration Services is finally picking up ODBC support. Another important feature slated for SSIS 2012 is the much needed support for CSV files.
The Balanced Data Distributor is a multithreaded data flow transform tool for SQL Server Integration Services 2008. It's intended to improve performance in multi-core and multi-processor server environments by distributing data to multiple outputs.
In conjunction with Attunity, Microsoft has released SSIS Connectors for Oracle and Teradata.
Microsoft and Unisys are claiming that they hold the record for loading information into a relational database. The unofficial benchmark was 1 TB of TPC-H data moved in under 30 minutes using an Extract, Transform, and Load (ETL) tool. The previous record for that volume was 45 minutes and was held by Informatica.
With the release of Service Pack 2, SQL Server 2005 finally has full support on Vista. This includes SQL Server Express, which had serious difficulties running on the new operating system. Several new features are also included in this release.
Jamie Thomson demonstrates how to use .NET scripts in a SQL Server Integration Services (SSIS) pipeline to add Regular Expression support.