Home Dashboard Directory Help
Search

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


Status: 

Active


33
0
Sign in
to vote
Type: Bug
ID: 729690
Opened: 3/8/2012 6:08:08 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

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).
Details
Sign in to post a comment.
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.
Sign in to post a workaround.