Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Unable to deploy SSIS packages from Visual Studio 2017 (15.8.0)

The latest version of Visual Studio 2017 (15.8.0) appears to have introduced a bug preventing deployment of SSIS project files.

When attempting to connect to a server the deployment wizard returns the following error:

TITLE: SQL Server Integration Services
------------------------------

Could not load file or assembly 'Microsoft.SqlServer.Management.IntegrationServicesEnum, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

------------------------------
ADDITIONAL INFORMATION:

The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

382 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Paul Bambury shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

80 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Wash commented  ·   ·  Flag as inappropriate

    Error persists on 15.9.7 version.

    Alternatively execute cmd line: ISDeploymentWizard.exe

  • Anonymous commented  ·   ·  Flag as inappropriate

    I just made the mistake of upgrading Visual Studio 2017 Community to version 15.9.7.

    I can't afford the delays this is going to cause me. I need to deploy packages and cannot! I have a project due date of March 4th. What the **** am I supposed to do now? I've wasted the whole day trying to fix this. Is there a **** solution???

  • Andreas commented  ·   ·  Flag as inappropriate

    Same issue here with VS 2017 15.9.5
    Try to deploy SSIS Project from VS to Integration Services Catalogs

  • IE commented  ·   ·  Flag as inappropriate

    Updated with the SSDT Standalone Installer for SSDT for Visual Studio 2017 (15.9.0) to get fixes included in that release and updated Visual Studio to 15.9.6. Now I'm hit with this. Sigh

  • Dale commented  ·   ·  Flag as inappropriate

    Microsoft Visual Studio Enterprise 2017 Version 15.9.6

    Unsupported
    This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them.
    For more information on enabling these project types or otherwise migrating your assets, please see the details in the "Migration Report" displayed after clicking OK.

  • Frendy commented  ·   ·  Flag as inappropriate

    Same issue here luckily we have an install of VS2017 on a dev server which was not updated to 15.8.0. Lets hope they start to test more rigorously before releasing these updates -.-

  • maxim commented  ·   ·  Flag as inappropriate

    DT 15.9.5 problem still there. Microsoft Visual Studio DT product team people please prove you deserve to work for microsoft.

  • Patrick commented  ·   ·  Flag as inappropriate

    So frustrated. Having the same issue. Uninstalled everything yesterday. Reinstalled VS2017 Enterprise without included SSDT. Installed standalone SSDT 15.8.2. Got Business Intelligence back and able to work. Brought laptop up this morning and Business Intelligence is gone. Get the "project incompatible" error messages.

  • MS DBA commented  ·   ·  Flag as inappropriate

    Any updates on this? I uninstalled and reinstalled both SSDT and VS, rebooted and installed the most updated version and I'm still getting this issue.

  • Michael Ward commented  ·   ·  Flag as inappropriate

    If you have to uninstall SSDT and then re-install it in order to fix this issue, I do not consider it fixed by Microsoft. I wish Microsoft would see it the same way.

← Previous 1 3 4

Feedback and Knowledge Base