locked
what 's the future of SSIS? RRS feed

  • Question

  • hi all,

    i noticed that for ssis, there was no changes between SQL Server 2008 and 2008 R2 (i wonder what's new in SQL Server code name DENALI).

    is it an indication that MS will NOT put much effort/resource into ssis? or should we shift to another ETL tool?

     

    Andrew


    Andrew
    BI, Data Mining, Analytical CRM
    Wednesday, September 7, 2011 1:35 PM

Answers

All replies

  • i wonder what's new in SQL Server code name DENALI

    MS has done many changes in upcoming version of SQL Server code name DENALI for SSIS

    http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/10/what-s-new-in-ssis-in-denali.aspx

    http://sqlblog.com/blogs/jorg_klein/archive/2011/07/22/ssis-denali-ctp3-what-s-new.aspx

    also read below thread

    http://social.msdn.microsoft.com/Forums/en-GB/sqlintegrationservices/thread/313b81ea-673e-4ebb-a6a2-880871462b27


    Shailesh , Please mark the post as answered if it answers your question.
    Wednesday, September 7, 2011 1:45 PM
  • See the official SSIS blog for what's new in SSIS Denali: http://blogs.msdn.com/b/mattm/

    RSS http://blogs.msdn.com/b/mattm/rss.aspx

    In my opinion SSIS ETL usage is sheer and Microsoft is addressing this appropriately by adding new features.

    Even though nothing significant was not added to SSIS 2008 R2, new components were created and there is a ton of free and paid 3rd party ones.

    Try to explore http://ssisctc.codeplex.com/ and you will quickly see that community support for SSIS is second to none when it comes to other ETL solutions.


    Arthur My Blog
    By: TwitterButtons.com
    Wednesday, September 7, 2011 1:45 PM
  • If only i noticed these changes months ago!

    many new wonderful features, while in the other hand, is it too different?


    Andrew
    BI, Data Mining, Analytical CRM
    Wednesday, September 7, 2011 2:05 PM
  • I think the SSIS changes course stays pretty consistent after the move to the SQL Server 2005 and as far as I can see will remain more or less the same for the next couple of SQL Server releases.

    Denali I see as a major release, and then a minor release will follow, so SSIS is here to stay for the next 5 years I think as near as to what it is.


    Arthur My Blog
    By: TwitterButtons.com
    Wednesday, September 7, 2011 2:11 PM
  • If only i noticed these changes months ago!

    many new wonderful features, while in the other hand, is it too different?


    Andrew
    BI, Data Mining, Analytical CRM
    The core functionality of SSIS (i.e. Dataflows, Control-Flow) is not changing in Denali so its arguable how different it actually is. Nonetheless there is lots and lots of new stuff around the periphary (i.e. introduction of the SSIS Server, dev tool enhancements) that make Denali a very exciting release (in my opinion).

    http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
    Jamie Thomson
    Wednesday, September 7, 2011 2:46 PM
  • Hi Jamie,

    I remembered that u ever posted an item on Microsoft Connect site  about hiding columns in the pipeline.

    "fixed" in this new version?

     

    Thanks


    Andrew
    BI, Data Mining, Analytical CRM
    Wednesday, September 7, 2011 3:03 PM
  • Hi Jamie,

    I remembered that u ever posted an item on Microsoft Connect site  about hiding columns in the pipeline.

    "fixed" in this new version?

     

    Thanks


    Andrew
    BI, Data Mining, Analytical CRM

    Simple answer. No. :)

    https://connect.microsoft.com/SQLServer/feedback/details/252462/ssis-hide-columns-in-the-pipeline

    To be honest, I regard this as a nice-to-have rather than something which is absolutely necassary. Given their finite resource there are many other things that I would prioritise higher than this.


    http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
    Jamie Thomson
    Wednesday, September 7, 2011 3:08 PM