SQL Server Integration Services 2012 to Include ODBC Support

by Jonathan Allen Follow 612 Followers on  Nov 25, 2011

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

by Jenni Konrad Follow 0 Followers on  Jun 02, 2011 1

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

by Jonathan Allen Follow 612 Followers on  Oct 10, 2008

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

by Jonathan Allen Follow 612 Followers on  Feb 28, 2008

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

by Jonathan Allen Follow 612 Followers on  Feb 21, 2007

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

by Jonathan Allen Follow 612 Followers on  Dec 27, 2006

Jamie Thomson demonstrates how to use .NET scripts in a SQL Server Integration Services (SSIS) pipeline to add Regular Expression support.

Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you