none
SQL Server with SSIS and SSAS in-place upgrade form 2016 to 2017 RRS feed

  • Question

  • We are doing an in-place upgrade of SQL Server 2016 with SSIS & SSAS to SQL Server 2017.

    Microsoft documentation shows the process. SQL Server part pretty straight forward but I got few questions about SSIS & SSAS as I don't know much knowledge about these Services.

    SSIS

    After upgrade, I will end up with 2 versions of SSIS Services (SSIS 13.0 and SSIS 14.0). Do I need to stop and disable the SSIS 13.0 ? or it needs to be remain place until the developers have upgraded the existing SSIS packages from 2016 to 2017 ?

    The documentation says the packages will automatically get upgraded at run time (temporary) every time they are run. Does the SSIS packages automatically run under SSIS 14.0 after upgrade or I need to change something (like SSISDB compatibility or update package individually somewhere) before they can run and until then they will continue to run in SSIS 13.0 compatibility mode.

    When can the SSIS 13.0 service stopped/disabled ?

    Can it be removed (and how its uninstalled) or it shouldn't be removed ?

    SSAS

    Is there anything I need to do explicitly post upgrade from Administration/configuration level for SSAS?


    • Edited by MiamiKK Thursday, July 18, 2019 4:10 PM
    Thursday, July 18, 2019 3:08 PM

Answers

  • Hi MiamiKK,

     

    >>After upgrade, I will end up with 2 versions of SSIS Services (SSIS 13.0 and SSIS 14.0). Do I need to stop and disable the SSIS 13.0 ? or it needs to be remain place until the developers have upgraded the existing SSIS packages from 2016 to 2017 ?

     

    Do not need to stop and disable the SSIS 13.0.

     

    >>The documentation says the packages will automatically get upgraded at run time (temporary) every time they are run. Does the SSIS packages automatically run under SSIS 14.0 after upgrade or I need to change something (like SSISDB compatibility or update package individually somewhere) before they can run and until then they will continue to run in SSIS 13.0 compatibility mode.

     

    When you upgrade an instance of SQL Server 2008 to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses. You will have to select an upgrade method and manually upgrade your packages.

    Refer to Upgrade Integration Services Packages.

     

    >>When can the SSIS 13.0 service stopped/disabled ?Can it be removed (and how its uninstalled) or it shouldn't be removed ?

    Do not need.

    When you upgrade to SQL Server 2017 Integration Services (SSIS) on a machine that has one of these earlier versions of Integration Services installed, SQL Server 2017 Integration Services (SSIS) is installed side-by-side with the earlier version.

     

    >>Is there anything I need to do explicitly post upgrade from Administration/configuration level for SSAS?

     

    No, you don't have to do anything. The upgrade process automatically migrates existing databases from the old instance to the new instance. For more details, please refer to https://docs.microsoft.com/zh-cn/sql/database-engine/install-windows/upgrade-analysis-services?view=sql-server-2017

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, July 19, 2019 8:30 AM