Post reply

Difference between SSIS 2005 , SSIS 2008 and SSIS 2008 R2

  • October 10, 2011 at 10:47 pm

    #390584

    Hi All,

    Can any tel me the difference between SSIS 2005 , SSIS 2008 and SSIS 2008 R2 ?

    Thanks & Regards

    Deepak

  • October 11, 2011 at 9:21 am

    #1392941

    I would start here.

    http://www.microsoft.com/sqlserver/en/us/product-info/previous-versions.aspx

    THanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

  • October 11, 2011 at 10:18 am

    #1392996

    What is your real question? What are you trying to answer?

    Between 2005 and 2008 the basic structure and capabilities are the same. In 2008 some of the components had options added to them, the most memorable for me was the Lookup component, they added a "No Match" output the the previous list of "Match Output" and "Error Output". There was some additional components added at the control-flow and data-flow levels.

    So I come back to, what are you trying to accomplish?

    CEWII

  • October 11, 2011 at 10:40 pm

    #1393220

    Elliott Whitlow (10/11/2011)

    There was some additional components added at the control-flow and data-flow levels.

    What are those additional components ?

  • October 11, 2011 at 10:41 pm

    #1393221

    Is there anything new in SQL 2008 R2 ?

  • October 11, 2011 at 11:23 pm

    #1393224

    I don't remember whats new between 2005 and 2008, sorry.. And between 2008 and R2 I think there is really nothing different..

    A list of whats different doesn't get you much..

    By and large new development should be on SQL 2008R2 at this point.

    Back to my original question, what are you trying to accomplish?

    CEWII

  • October 11, 2011 at 11:31 pm

    #1393227

    Elliott Whitlow (10/11/2011)

    Back to my original question, what are you trying to accomplish?

    CEWII

    Currently i'm using 2005 , we are palnning to use 2008 so to learn and understand the new things and its advantages , pros and cons ...

    Regards - Deepak

  • October 12, 2011 at 9:55 am

    #1393559

    Whats New in SQL 2008

    http://msdn.microsoft.com/en-us/library/bb500435(v=SQL.100).aspx

    Whats New in SQL 2008R2

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

    Give those a whirl..

    CEWII

Viewing 8 posts - 1 through 7 (of 7 total)

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