I need explanations for creating and deploying SSIS packages.

Question

I need to develop a set of ETL packages for my company.

My scenario is: my local pc with Visual Studio 2022 and SQL Express Ed. installed (development and testing environment) and a remote db server with an instance of SQL Server 2019 Standard Ed. (production environment).

In terms of licensing, can I download and install the SSDT tool on the local pc to create and test SSIS packages to then deploy to the production server?

Thanks in advance for your attention

Answer 1

Hi @Carlo Maria Carnevale，

In order to develop and test SSIS packages on your test environment, you may use Visual Studio free on your test environment.

In terms of licensing, can I download and install the SSDT tool on the local pc to create and test SSIS packages to then deploy to the production server

Yes you can, because you have SQL Server 2019 Standard Ed license on your production server.

Regards，

Zoe Hui

---

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

Answer 2

Hi @Carlo Maria Carnevale,

There is no need in SSDT anymore.

You need to install SQL Server Integration Services Projects 2022 extension for VS 2022 on your development machine. It is free of charge.

Here is its download link: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

As end result, your SSIS development PC needs the following:

• VS2022
• SQL Server Integration Services Projects 2022 extension for VS 2022. It is free of charge.

SQL Server license is needed just on the SSIS run-time servers where MS SQL Server instance is installed.

Answer 3

Hi @Carlo Maria Carnevale，

Visual Studio is free to use if you want to develop SQL-BI(SSRS,SSIS,SSAS) job.

You only need the license for SQL Server.

Regards，

Zoe Hui

---

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

Answer 4

Hi Zoe,

My concern is that my IT department tells me that in order to develop and test SSIS packages I need a paid SQL license on my pc as well and not just on the production db server.

Is this correct?

Because the alternative scenario might be to install VS2022 on the production server, but it seems a bit strange to me to pay for another VS2022 PRO subscription on the db server just for ETL package management (my company does not accept the community version of VS).