BT

Your opinion matters! Please fill in the InfoQ Survey!

SQL Server Integration Services 2012 to Include ODBC Support

| by Jonathan Allen Follow 189 Followers on Nov 25, 2011. Estimated reading time: 1 minute |

With SQL Server abandoning OleDB in favor of ODBC, it is no surprise that SQL Server Integration Services is finally picking up ODBC support. Microsoft’s partners on the feature, Attunity, are also working on a SSIS feature called Change Data Capture. Details are still sparse; this is what we know so far:

This includes a CDC Control Task, a CDC Source component, and a CDC Splitter transform (that splits the output based on the CDC operation – insert/update/delete). It also includes CDC support for Oracle.

An important feature is the much overdue support for the popular CSV or Comma-Separated Values format. The current version of SSIS is unable to parse CSV files that include embedded double-quotes and commas. They are also adding support for flat files with a varying number of columns in each record.

To add with development, parameters can be externalized. When running under Visual Studio, the same configuration settings you use for .NET projects (e.g. Debug/Release) can be used for changing parameter values. Another debugging feature is the ability to add “data taps”. A data tap can be programmatically added in production to inspect data flowing through a package. Logs are saved as CSV files.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

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


Recover your password...

Follow

Follow your favorite topics and editors

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

Like

More signal, less noise

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

Notifications

Stay up-to-date

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

BT