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
------------------------------
Paul Bambury
shared this idea
50 comments
-
Kristian Svedal
commented
Had no issue with package deployment in SSIS from within SSDT before recently upgrading to 15.8.6. Receiving same error message as OP.
-
Phil D
commented
15.8.6 same error on prem
-
javier
commented
15.8.6 same kind of issue, thanks
-
Anonymous
commented
15.8.6 same kind of issue
-
Sergej Steinhauer
commented
It works for me after Update VS 2017 to 15.8.3 and reinstall SSDT from posted link.
-
WGA
commented
Allegedly fixed in the current Release of SSDT version: 14.0.16174.0 - Release date: September 05, 2018.
https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017
I can not test it right now. Can anyone confirm? -
Tom Adams
commented
Just check after updating to 15.8.3 still broken
-
Anonymous
commented
This is fixed in the newest release, buil number 14.0.16174.0:
-
Anonymous
commented
Why did we ever upgrade from VS 2008...
-
Bhaskar
commented
Same Issue, its Annoying.. rolling back to older version is a poor solution. I cant deploy to catalog. Please fix it soon.
-
Matt Benham
commented
Agreed Boka, similarly in addition to the deployment issues, I had a working project suddenly crash VS without error every time upon build. It builds fine after installing an older (trial) version of VS. Didn't bother investigating further as I couldn't deploy anyway. The deploy issue may have just scratched the surface of problems in these versions.
-
Boka
commented
You can deploy ispac as a workaround but during execution I'm getting unreasonable validation errors. After deploying the same project from different PC with older SSDT error disappear. Deployment is completely messed up. Turn it back prior to 15.8
-
Reinis
commented
Same issue. It's hard to convince ppl to use the catalog when you Visual Studio can't even deploy to it.
-
Boka
commented
Just installed 15.8.2 and problem still exists. You can use other deployment tools but it's really annoying!
-
Anonymous
commented
very disappointing. would like this fixed as soon as possible. I'm dead in the water
-
Anonymous
commented
Using the external Sql Server Deployment wizard is the only workaround i found.
-
Tim Hampton
commented
What's most annoying about this issue is that Microsoft has yet to make any mention of this as an issue they're officially aware of and working to fix. Two new revisions (x.1 and x.2) and diddly-squat about this.
-
fhn
commented
Same issue after update to VS2017 15.8.2
-
Ole-Kr
commented
Same issuer here. Version 15.8.2
-
Sergej Steinhauer (Z3RG)
commented
Same issue after update to VS2017 15.8.2