SQL Server integration service installed with SQL Server management studio

Question

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?

Answer 1

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.

Answer 2

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.

Answer 3

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.