BT
x Share your thoughts on trends and content!

SQL Server Integration Services 2012 to Include ODBC Support

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

Relevance
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
General Feedback
Bugs
Advertising
Editorial
Marketing
InfoQ.com and all content copyright © 2006-2016 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT

We notice you're using an ad blocker

We understand why you use ad blockers. However to keep InfoQ free we need your support. InfoQ will not provide your data to third parties without individual opt-in consent. We only work with advertisers relevant to our readers. Please consider whitelisting us.