none
How to check edition of SSIS (no db engine)?

    Question

  • Is there a way to check the edition of SSIS? i've tried connecting to SSIS through SSMS and looking at the reports, but that just gives me the version number.

    there is no database so SELECT @@version doesn't apply. It's also possible to have different editions of sql db engine and SSIS installed on the same server so that's more of an inferred edition rather than the actual ssis edition. i want to find out from SSIS directly what edition it is


    Jakub @ Adelaide, Australia

    Wednesday, July 09, 2014 5:06 AM

Answers

  • You can try this:

    Use regedit to peek at the registry.

    Look for HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Microsoft SQL Server\{100|110, where 100 = SQL 2008{r2} and 110 = SQL 2012} \Tools\Setup\

    You will see the edition listed.

    • Marked as answer by jakubk Thursday, July 10, 2014 3:42 AM
    Thursday, July 10, 2014 3:33 AM

All replies