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
Bambury, Paul
shared this idea
96 comments
-
Luc Bärtschi
commented
Workaround to deploy: Open the project folder of your ssis package. Navigate to bin folder and double klick the .ispac file on the SQL server to deploy it manually.
-
Drew Hazen
commented
Thanks, Wash! This worked for me:
Alternatively execute cmd line: ISDeploymentWizard.exe
-
Simon
commented
This is still happening in 15.9.24 as far as I can tell.
-
Ran Ye
commented
The issue had been fixed. Please upgrade to latest SSDT for VS2017 https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15.
-
Anonymous
commented
15.9.21 same problem here. That sucks
-
Plantje
commented
Yes, the same problem occurs with 15.9.17. Noticed that 15.9.18 is currently available, does that fix the issue?
-
Nate Irvin
commented
For me it comes and goes with every VS update - it's working for me now, but wasn't the version before, and was the version before that, etc.
-
Elisabeth Wagner
commented
The same problem with 15.9.17
-
Dawid
commented
Shame...
-
Really upset VS user
commented
15.9.14 - still no love
-
Really upset VS user
commented
Anyone???
-
Anonymous
commented
The same problem with 15.9.13
-
Krzysztof
commented
The same problem with VS 15.9.12
-
Yurii
commented
The same problem with VS 15.9.12
-
Phil Brown
commented
get with it, MS. your product is 2 years old and doesn't work yet
-
Anonymous
commented
404 broken link
-
Connect Me
-
Wash
commented
Error persists on 15.9.7 version.
Alternatively execute cmd line: ISDeploymentWizard.exe
-
Smurfette
commented
Is there a solution to this? I'm on 15.9.4 and I can't deploy SSIS packages.
-
Anonymous
commented
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???
