SQL Server integration service installed with SQL Server management studio

Srinivas Ramanujaiah 0 Reputation points
2024-05-27T06:59:06.6266667+00:00

Hi

Can you please let us know if SQL Server integration service (or SSIS) which is a licensable product installed with SQL Server management studio (SSMS) (a non licensable product)? We have got instances of our DBAs mentioning that they can see integration service installed with SQL Server management studio? You can see below too..

The question is

  1. Is SQL Server integration service installed with SQL Server management studio?
  2. If yes, how can a licensable product be installed with a non licensable product? Is this installation free for use?
  3. How can we differentiate this installation of SQL Server integration service that is installed as part of SSMS?

Image 27-05-2024 at 08.47

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,184 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,746 Reputation points
    2024-05-27T07:21:54.4633333+00:00

    Is SQL Server integration service installed with SQL Server management studio?

    No, SSMS is just a tool without any services.

    Is this installation free for use?

    SSIS is not for free, you have to purchase a SQL Server license.

    installed as part of SSMS?

    Again, SSMS is just a tool, nothing more.

  2. ZoeHui-MSFT 34,756 Reputation points
    2024-05-27T08:54:54.7233333+00:00

    Hi @Srinivas Ramanujaiah,

    Is SQL Server integration service installed with SQL Server management studio?

    NO, SSIS is a is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems.

    It will be installed with SQL Server, once you have paid for SQL Server, you may use SSIS free with the license for SQL Server.

    SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. It is a full free tool.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. Erland Sommarskog 105.1K Reputation points MVP
    2024-05-27T21:47:55.29+00:00

    With SSMS you get a couple of import/export features, and you also get database maintenance plans. And they are indeed implemented as SSIS packages. So, yes, I guess that with SSMS you get a stripped-down version of SSIS for these specific tasks, but you cannot use it for your own packages.