Post installation of SSIS for existing SQL Server instance with different build versions

Posted on

Question :

I would like to install SSIS into existing SQL Server 2014 Fail-over cluster instance with latest cumulative update 7 which was applied. I know how to do it but I want to know if consistency of versions between SSIS (from installation disc) and SQL Server 2014 (already updated) will be kept at the same latest server version (latest version is 12.0.2560).

In to detail, I mean I have latest CU7 update applied but I want to install SSIS from image where is first RTM version release 12.0.2000 but currently I have 12.0.2560 CU7 Server version which is newer. Will be there conflict of versions or SSIS has no impact which version of SQL Server is actually installed? I can also download image of SQL Server 2014 with SP1, but build version is higher than actual CU7 (SP1 is 12.0.4100 build version and CU7 with fixes 12.0.2560 build version). Reason why I don’t want to install SP1 even when build version is higher has less fixed bugs than actual CU7.

So in result does post-installation of SSIS downgrade SQL Server version to which installation media contains or it will be self-upgraded to actual server installed version?

Answer :

I have answer for this question from member of Microsoft Technet called Lydia Zhang:

…SSIS will inherit the patch level that your installation media contains, which has no impact on the patch level of your existing SQL Server 2014 failover cluster instance…

So my question is resolved.

Leave a Reply

Your email address will not be published. Required fields are marked *