SSIS does not support Non-MS ODBC drivers

  • Please let me know if this statement is Right or Wrong!

  • Incorrect. If it's a functional Windows ODBC driver, it will function. Now, what you need to do to make it function will depend on the driver, it's personal quirks, and similar problems.

    For a perfect example: Oracle drivers.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Thanks Craig!

    Thank you so much!

    Please provide me any link that supports this arguement. I am unable to find it. This will be a lot helpfull to me

    Thanks in Advance!

  • Simply the first hit I found on my first google attempt:

    http://blogs.msdn.com/b/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx

    There's a ton out there. Just google 'ODBC SSIS driver'. Pick your concerned software if you have one and include it.

    Google is your friend. If you run into particular questions come on back and we'll try to help, but in most cases your best bet for inconsistencies or quirks with any particular driver is the primary product manufacturer's forums or FAQs.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply