Share via

Visual Studio Community Integration Services and Licensing

Rino Yaohari 20 Reputation points
2024-12-30T13:23:51.98+00:00

Hello,

My questions probably been asked before but I need to be sure and would like to know, what is the difference using community and enterprise version?

Let say i have a limited resource , what if I purchase SQL Server License, made a SSIS package using Visual Studio Community Edition, deploy the package and run it through the Scheduler in SQL Server, does it work? will it have a legal problem later?

Or do I have to purchase enterprise edition for Visual Studio for it to work?

If the scenario where i purchase SQL Server license and use the community edition for Visual Studio is possible, what problem would likely to occur in the long run?

Thanks for any help for my questions !

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,243 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,623 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
238 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 26,296 Reputation points
    2024-12-30T16:42:04.6133333+00:00

    Hi @Rino Yaohari,

    SSIS Developer Workstation needs the following:

    • Visual Studio (any edition), VS2019 or VS2022.
    • SQL Server Integration Services Projects extension for Visual Studio.

    Extension is different depending on VS2019, or VS2022.
    Combination of VS and its SSIS extension allows to develop SSIS projects targeting any, i.e. regular or enterprise, SSIS run-time environment on a server.

    SSIS run-time environment on a server needs the following:

    • SQL Server relational database instance. It could be regular or enterprise edition.
      Some SSIS tasks are available for the SQL Server enterprise edition only. Or they are targeting specific SQL Server versions. For example, Microsoft Connector for Oracle has two pre-condition. It will work just and only on (1) SQL Server 2019 and later, and (2) enterprise edition only.
    • SSIS component of SQL Server instance.
    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,271 Reputation points
    2024-12-31T01:56:33.5333333+00:00

    Hi @Rino Yaohari,

    As said in Visual Studio license:

    Any number of your users may use the software only for Microsoft SQL Server development when using the SQL Server Data Tools or the extensions “Microsoft Analysis Services Projects”, “Microsoft Reporting Services Projects”, or “SQL Server Integration Services Projects” to develop Microsoft SQL Server database projects or Analysis Services, Reporting Services, Power BI Report Server, or Integration Services projects.

    If you have purchase SQL Server License, you do not need to pay for VS and can use SSIS without any concerns.

    Regards，

    Zoe Hui

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

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.