SSIS 2012 - Native Client

  • Comments posted to this topic are about the item SSIS 2012 - Native Client

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good one, learnt something new 🙂

    M&M

  • This was removed by the editor as SPAM

  • Always optimistic about backwards compatibility... Always let down...

  • Dalton Moore (6/18/2012)


    Always optimistic about backwards compatibility... Always let down...

    The install guide does say that it will be installed side-by-side with earlier versions though, if they already exist on your system. Does this mean you'd still be able to connect to SQL Server 2000 in SSIS 2012 using the previous Native Client?

    http://msdn.microsoft.com/en-us/library/ms131321.aspx

  • thanks for the question

  • Thank you for the question.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • Coin flip, I got it right. Thanks for the question.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • Great question.

  • sestell1 (6/18/2012)


    Dalton Moore (6/18/2012)


    Always optimistic about backwards compatibility... Always let down...

    The install guide does say that it will be installed side-by-side with earlier versions though, if they already exist on your system. Does this mean you'd still be able to connect to SQL Server 2000 in SSIS 2012 using the previous Native Client?

    http://msdn.microsoft.com/en-us/library/ms131321.aspx%5B/quote%5D

    I believe you can. Haven't tested it myself to be honest (I don't have SQL 2000 installations).

    But I think it is interesting to know. Say your planning to migrate some 2000 instances to a new server. You install SQL Server 2012 on the new server and fire up SSIS to move all the data. Whoopsies 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • While the question was great, the answer was wrong, two versions back from 2012 is 2008 2005 is not supported accroding to your reference.

    Thanks for the question though.

  • Lon-860191 (6/22/2012)


    While the question was great, the answer was wrong, two versions back from 2012 is 2008 2005 is not supported accroding to your reference.

    Thanks for the question though.

    You forget that SQL Server 2008R2 counts as a seperate value.

    (I don't agree with the policy, I'm just explaining it).


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Good question Koen... I didn't know it only supported a limited set of versions. Thanks.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Dalton Moore (6/18/2012)


    Always optimistic about backwards compatibility... Always let down...

    I'm always optimistic about backwards compatability too, and if I had been often let down I would have changed to pessimism. Maybe SSIS is an area in which pessimism is appropriate, unlike most of SQL Server? (I got this one wrong, of course, because I'm still optimistic - that may be a result of my lack of experience with SSIS.)

    Tom

  • Interesting question, thanks!

Viewing 15 posts - 1 through 14 (of 14 total)

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