SQL Server Integration Services 2012 to Include ODBC Support
- Share
-
- |
Read later
My Reading List
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.
Educational Content
Concurrency in Clojure
Stuart Halloway May 17, 2013
Confessions of an Agile Addict
Ole Friis Østergaard May 16, 2013
Web Development: You're Doing It Wrong
Stefan Tilkov May 16, 2013
Programming The Feynman Way
Ben Evans May 15, 2013
Hello stranger!
You need to Register an InfoQ account 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