Tuesday, October 28, 2008

SSIS Tip - result binding by name is not supported for this connection type

In SSIS when I tried to bind the ADO.NET Result Set to a User Variable by the 'RecordSet Column Name', I got the error 'result binding by name is not supported for this connection type'. The I found that the 'Result Set - Result Name' should be changed to Index of the Column in the Result Set like 0, 1.
Posted by Vijay at 10:19 AM
Labels:

13 comments:

  1. AnonymousNovember 6, 2009 at 12:05 PM

    i was lost in this shit. thanks a lot man!

    ReplyDelete
  2. SankarApril 29, 2010 at 6:35 AM

    thanks it works

    ReplyDelete
  3. AnonymousJuly 19, 2010 at 4:01 PM

    Agree. You just saved me a lot of time. Thanks!

    ReplyDelete
  4. karthikDecember 22, 2011 at 6:28 AM

    thanks a lot...

    ReplyDelete
  5. AnonymousApril 27, 2012 at 5:46 PM

    Excelente !! Thnks

    ReplyDelete
  6. AnonymousJuly 6, 2012 at 7:57 AM

    Thanks for this - simple but causing me a pain - all sorted now.

    ReplyDelete
  7. AnonymousAugust 15, 2013 at 2:12 AM

    Thank you very much! :)

    ReplyDelete
  8. AnonymousNovember 27, 2013 at 7:35 AM

    Thank you!

    ReplyDelete
  9. AnonymousMarch 5, 2014 at 4:11 PM

    Thank a lot man. Really helped me a lot

    ReplyDelete
  10. AnonymousJune 10, 2014 at 5:32 PM

    It previously worked for me with the name, but didn't in the new package I was creating. Ypur tip saved me from a lot of frustration

    ReplyDelete
  11. AnonymousJune 18, 2014 at 5:20 PM

    +1. Ty mucho!

    ReplyDelete
  12. AnonymousJuly 15, 2014 at 10:45 AM

    Thank you - a real time saver

    ReplyDelete
  13. AnonymousSeptember 30, 2014 at 2:11 PM

    Thank you very much!

    ReplyDelete

Subscribe to: Post Comments (Atom)