Incompatible SSIS VS 2019 2022

Question

Incompatible SSIS VS 2019 2022

Anders Johansson 5

I had a Visual Studio 2019 SSIS project that worked fine. I wanted to get it to work with VS 2022, but all the files said (incompatible) and "The application is not installed". I Installed SSIS extension for 2022, I installed "Microsoft Reporting Services Project", but it didn't work. I reinstalled everything, both 2019 and 2022, reinstalled SSIS extension for both versions. Now I the project is the same way in both 2019 and 2022. Incompatible and "The application is not installed". I have tried right clicking "reload" and also "resolve errors. No luck. What can I do to make it work?

Yitzhak Khabinsky 26,486 Reputation points

2023-11-21T14:29:50.15+00:00

@Anders Johansson,

What version of SSIS extension for VS2022 did you install? Was it v.1.2?
Anders Johansson 5 Reputation points

2023-11-21T14:41:12.8533333+00:00

I installed SSIS Extension 4.5 for VS 2019, and SSIS Extension 1.3 for VS 2022. I Have tried to clean, rebuild, and the SSIS extension is enabled in Extension Manager. Thank you for your response.

I'm doing a repair on VS 2022 now. Does this have something to do with 32/64-bit versions?

The SQL Server version is 2019, in compatibility mode 2012, if that is relevant at all.
Anders Johansson 5 Reputation points

2023-11-21T14:43:26.4266667+00:00

I'm doing a repair on VS 2022 now. Does this have something to do with 32/64-bit versions?
Anders Johansson 5 Reputation points

2023-11-21T14:46:34.48+00:00

The SQL Server version is 2019, in compatibility mode 2012, if that is relevant at all.
Anders Johansson 5 Reputation points

2023-11-22T08:11:39.58+00:00

Ok, I realized I couldn't even create a new SSIS project with 2022. It says "Strong name validation failed" when trying to create.

2 answers

Your answer

Yitzhak Khabinsky 26,486 Reputation points

2023-11-21T14:29:50.15+00:00

@Anders Johansson,

What version of SSIS extension for VS2022 did you install? Was it v.1.2?
Anders Johansson 5 Reputation points

2023-11-21T14:41:12.8533333+00:00

I installed SSIS Extension 4.5 for VS 2019, and SSIS Extension 1.3 for VS 2022. I Have tried to clean, rebuild, and the SSIS extension is enabled in Extension Manager. Thank you for your response.

I'm doing a repair on VS 2022 now. Does this have something to do with 32/64-bit versions?

The SQL Server version is 2019, in compatibility mode 2012, if that is relevant at all.
Anders Johansson 5 Reputation points

2023-11-21T14:43:26.4266667+00:00

I'm doing a repair on VS 2022 now. Does this have something to do with 32/64-bit versions?
Anders Johansson 5 Reputation points

2023-11-21T14:46:34.48+00:00

The SQL Server version is 2019, in compatibility mode 2012, if that is relevant at all.
Anders Johansson 5 Reputation points

2023-11-22T08:11:39.58+00:00

Ok, I realized I couldn't even create a new SSIS project with 2022. It says "Strong name validation failed" when trying to create.

Answer 1

Anna Xiu-MSFT 30,956 Microsoft External Staff

Hi @Anders Johansson,

Welcome to Microsoft Q&A!

Please try the following:

Open Visual Studio Installer > Modify > check that you have the Data storage and processing workload installed.
Launch Visual Studio > Extension > Manage Extensions > Installed > ensure that the SSIS extension is enabled.
Right-clicking on the solution in the Solution Explorer, if you can find the “Resolve Errors”, please click on it.
Right-clicking on the project in the Solution Explorer > Reload project.

Sincerely,

Anna

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Anders Johansson 5 Reputation points

2023-11-22T09:43:03.7433333+00:00

I have done all of that. Resolve errors just generates the same error. Reload does the same thing.
SQLDeveloper2022 0 Reputation points

2024-02-09T23:04:42.08+00:00

I installed VS2022, SSDT and SSIS projects 2022. When I Launch Visual Studio > Extension > Manage Extensions > Installed, The SSIS project extension doesn't show up on the list. The SSDT is on the list. I can't enable the SSIS project extension. Can you please tell me what went wrong?
Yitzhak Khabinsky 26,486 Reputation points

2024-02-11T00:22:19.5133333+00:00

@SQLDeveloper2022, SSDT lifespan for SSIS development ended with VS2017. Starting from VS2019 onwards you need to download and install "SQL Server Integration Services Projects" extension. Here is its download link for VS2022: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

Answer 2

Yitzhak Khabinsky 26,486

@Anders Johansson,

If you are having problems with VS2022, I would suggest to stay with VS2019 for now. SSIS extension for VS2022 is still not ready for prime time.

Also, all versions of it after v1.0 are not General Availability (GA) releases.

Share via

Incompatible SSIS VS 2019 2022

2 answers

Your answer