InfoQ Homepage SQL Server Integration Services Content on InfoQ
News
RSS Feed-
SQL Server Integration Services 2012 to Include ODBC Support
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.
-
Balanced Data Distributor: Improve SSIS Performance with Parallelism
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.
-
SSIS for Oracle and Teradata
In conjunction with Attunity, Microsoft has released SSIS Connectors for Oracle and Teradata.
-
Microsoft Claims to Hold the ETL Record at 1 TB in 30 Minutes
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.
-
SQL Server Now Supports Vista
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.
-
Using Regular Expressions in SQL Server Integration Services
Jamie Thomson demonstrates how to use .NET scripts in a SQL Server Integration Services (SSIS) pipeline to add Regular Expression support.