Deploying SSIS Package - 'Failed to load Assembly Microsoft.SqlServer.Management.IntegrationServicesEnum'

sql-server ssis sql-server-2016
aldredd picture aldredd · Dec 23, 2016 · Viewed 9k times · Source

I have a fresh install of SQL Server 2016 Developer with SSIS, on a clean install of Windows 10

When I try to deploy an SSIS package (developed on the same machine), when I come to select the destination server, I instantly get an error;

Failed to load assembly Microsoft.SqlServer.Management.IntegrationServicesEnum

Selecting 'details' doesn't seem to add much

Could not load file or assembly Microsoft.SqlServer.Management.IntegrationServicesEnum, Cluture=Neutral, PublicKeyToken=xxx

I've tried doing a repair on the install, to no avail. I've also tried referring to it as both the proper computer name, and localhost, but gives the same error

It's not my first time setting up SQLS & SSIS, but don't recall having any such issues before. The catalog has been created, but wonder if I've missed something out.

Answer

aldredd picture aldredd · Dec 28, 2016

Ok, here are the steps I took to resolve the issue (eventually!)

  • I uninstalled all programs relating to Sql Server Data Tools (inc Management Studio, SharedManagementObjects) and anything related to Visual Studio, leaving pretty much just the core database engine and SSIS.
  • I performed a 'repair' on what was left of my SQLS installation, mainly to restore anything I'd removed that I shouldn't have
  • I then re-downloaded & installed Sql Server Data Tools & Management Studio

Everything now seems to be working as it should.

Related questions

SSIS Error: VS_NEEDSNEWMETADATA

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2). While updating one of the ETLs and trying to run on the new …

Read More
Run SSIS Package Without SQL Server Integration Services

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement. The problem statement is as follow: I am using SQL Azure database to store the data. I …

Read More
SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the SSIS Catalog, I receive the below error: Execute SQL Task: Error: Failed …

Read More