"Incompatible" project

Question

"Incompatible" project

Lusk, Colin 25

(Relatively new to SSIS so apologies if this is an easy one)

I set up a data flow in the community version of VS as a proof of concept. Then moved to the enterprise version but opened the old project before installing SSIS and of course it said the project was incompatible because the application wasn't installed. I have subsequently installed it but the old project still doesn't work and still says the same. Can I unfudge it or it permafudged?

EDIT: Visual Studio 17.9

SSIS 1.4

And the error message looks like this

Untitled

Lusk, Colin 25 Reputation points

2024-07-16T16:42:14.0533333+00:00

Thanks @Yitzhak Khabinsky I'm embarrassed I didn't do that in the first place
ZoeHui-MSFT 41,551 Reputation points

2024-07-17T01:41:34.1133333+00:00

hi @Lusk, Colin,

Glad to hear that the issue has been resolved, you could mark it as answer so other user with similar problem could see this easier.
Lusk, Colin 25 Reputation points

2024-07-19T10:51:50.8733333+00:00

ZoeHui-MSFT It hasn't been resolved, someone just asked for more information.

Answer accepted by question author

ZoeHui-MSFT 41,551

Hi @Lusk, Colin,

Please help check if you can create a new ssis project successfully, if you cannot, please install the SQL Server Data Tools first. And go to Extensions > Manage Extensions > Installed in VS, make sure that the SSIS extension is enabled.

If you could create ssis project, please right-click on the incompatible project and choose "Resolve Errors".

Regards，

Zoe Hui

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

Lusk, Colin 25 Reputation points

2024-07-22T06:37:11.39+00:00

Thanks for the reply. I definitely can start a new SSIS project. I tried to follow your advice but I couldn't fine the "Resolve Errors" by right-clicking it in the solution explorer. However, while there I did manage to find an option that said "Reload with dependencies" (might not be exact wording) and tried that. The project opened and no longer says it's invalid.

However, a warning came up that says "the package file 'Package.dtsx' is missing from the project directory. The package was skipped. The project will continue to load. I was able to find that file though, by using "open file" and digging into the subfolders, so I got there in the end!

Thanks for your help.

1 additional answer

Your answer

Lusk, Colin 25 Reputation points

2024-07-16T16:42:14.0533333+00:00

Thanks @Yitzhak Khabinsky I'm embarrassed I didn't do that in the first place
ZoeHui-MSFT 41,551 Reputation points

2024-07-17T01:41:34.1133333+00:00

hi @Lusk, Colin,

Glad to hear that the issue has been resolved, you could mark it as answer so other user with similar problem could see this easier.
Lusk, Colin 25 Reputation points

2024-07-19T10:51:50.8733333+00:00

ZoeHui-MSFT It hasn't been resolved, someone just asked for more information.
Lusk, Colin 25 Reputation points

2024-07-22T06:37:11.39+00:00

Thanks for the reply. I definitely can start a new SSIS project. I tried to follow your advice but I couldn't fine the "Resolve Errors" by right-clicking it in the solution explorer. However, while there I did manage to find an option that said "Reload with dependencies" (might not be exact wording) and tried that. The project opened and no longer says it's invalid.

However, a warning came up that says "the package file 'Package.dtsx' is missing from the project directory. The package was skipped. The project will continue to load. I was able to find that file though, by using "open file" and digging into the subfolders, so I got there in the end!

Thanks for your help.

Answer 1

Yitzhak Khabinsky 27,116

@Lusk, Colin,

Please edit your original question, and provide the following:

Visual Studio version, and its build.
SSIS extension for Visual Studio, and its version.
Exact error message in its entirety.

So, you are using VS2022, build 17.9, and SQL Server Integration Services Projects extension for VS 2022, v.1.4

You can try the following to resolve the issue:

Right mouse click on the Project level (not solution), i.e. DataWrangling (incompatible), and select Reload option.

0 comments

Share via

"Incompatible" project

1 additional answer

Your answer