Post reply

SSIS 2012 - Native Client

  • June 17, 2012 at 3:13 am

    #258181

    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

  • June 17, 2012 at 3:14 am

    #1501998

    Good one, learnt something new 🙂

    M&M

  • June 18, 2012 at 2:47 am

    This was removed by the editor as SPAM

  • June 18, 2012 at 7:22 am

    #1502222

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

  • June 18, 2012 at 8:07 am

    #1502242

    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

  • June 18, 2012 at 9:07 am

    #1502283

    thanks for the question

  • June 18, 2012 at 9:30 am

    #1502298

    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]

  • June 18, 2012 at 9:54 am

    #1502313

    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.

  • June 18, 2012 at 11:52 am

    #1502368

    Great question.

  • June 18, 2012 at 12:51 pm

    #1502404

    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

  • June 22, 2012 at 9:04 am

    #1504551

    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.

  • June 22, 2012 at 9:15 am

    #1504563

    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/

  • July 1, 2012 at 7:32 pm

    #1507582

    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

  • July 18, 2012 at 10:14 am

    #1514334

    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

  • August 9, 2012 at 8:32 am

    #1523825

    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