'Microsoft.DataTransformationServices.Wizards' error in VS 2017

Question

I have been using SSIS for VS 2017 for about a month without troubles.

Suddenly, when I try to create a new SSIS project the following error dialog box appears:

Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system cannot find the file specified.

I have tried to uninstall SSIS package and to reinstall VS 2017 but the error still appears. Could you help me with it?

Answer 1

Actually the solution for me is simple. Some how the Integration Services is disabled. Re-enable it. Open your Visual Studio SSDT, go to Tools >> Extension and Update and Enable the "Microsoft Integration Services Projects".

Answer 2

I was also getting the same error message when I tried to open VS 2017 Integration Services projects. I fixed it by enabling the feature for Integration Services in TOOLS >> Extensions and Updates >> Integration services >> Enable.

Answer 3

By doing this it worked for meTOOLS >> Extensions and Updates >> Integration services >> Enable.