ODBC Connection Manager does not have same funcitonality as OLE DB [SSIS] - by Jamie Thomson

Status : 


Sign in
to vote
ID 729690 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 3/8/2012 6:08:08 AM
Access Restriction Public


In line with the advice that we should be using ODBC rather than OLE DB (http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with-odbc-for-native-relational-data-access.aspx) I just began a new project and added a new ODBC Connection Manager. My SQL statement was:

SELECT SomeColumn FROM [SomeSchema].[SomeFunction](?)

and inserting the results into an Object variable. It failed with error:
"Disconnected recordsets are not available from ODBC connections."

This was discovered in Denali RC0
I switched to using an OLE DB Connection Manager (which, by the way, required me to change my parameter name in the Parameter Mapping tab from 1 to 0 - very odd) and everything worked fine.

I presume from this that ODBC Connection Managers don't work properly with SSIS and we should continue to use OLE DB (contravening the advice on the blog post linked to above).
Sign in to post a comment.
Posted by jljohnson in Wisconsin on 10/9/2015 at 9:26 AM
Has there been any progress on this? Or should we continue to use OLE DB connections with SSIS in VS2010 and VS2012?
Posted by Microsoft on 7/11/2012 at 9:01 PM
Hi Jamie,

Thank you for your feedback. We are actively looking at the issue and will keep you updated.