BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!
rss

SQL Server Integration Services 2012 to Include ODBC Support

by Jonathan Allen on  Nov 25, 2011 2

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 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 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 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 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 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.

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT