在VS 2017更新15.8.0之后无法部署SSIS [英] Unable to deploy SSIS after VS 2017 update 15.8.0
问题描述
我刚刚将15.8.0更新安装到Visual Studio 2017，现在我无法从Visual Studio 2017中将SSIS项目和包部署到SSIS目录。
部署向导但是，仍然可以从命令行工作。
I just installed the 15.8.0 update to Visual Studio 2017 and now I am unable to deploy SSIS projects and packages to the SSIS Catalog from within Visual Studio 2017. The Deployment Wizard does still work from the command line, however.
我修复了SQL Server数据工具。我已经修复了Visual Studio 2017.我已经卸载并重新安装了SQL Server Integration Services项目。最终结果是相同的：
I have repaired SQL Server Data Tools. I have repaired Visual Studio 2017. I have uninstalled and reinstalled SQL Server Integration Services Projects. The end result is the same:
ETA：在"连接"之后发生此错误。点击"选择目的地"按钮向导的页面。
ETA: This error occurs after the "Connect" button is clicked on the "Select Destination" page of the Wizard.
================================== =
$
无法加载文件或程序集"Microsoft.SqlServer.Management.IntegrationServicesEnum，Culture = neutral，PublicKeyToken = 89845dcd8080cc91"或其中一个依赖项。参数不正确。 （HRESULT异常：0x80070057（E_INVALIDARG））（mscorlib）
----------------- -------------
节目位置：
at System.Reflection.RuntimeAssembly._nLoad（AssemblyName fileName，String codeBase，Evidence assemblySecurity，RuntimeAssembly locationHint，StackCrawlMark& stackMark，IntPtr pPrivHostBinder，Boolean throwOnFileNotFound，Boolean forIntrospection，
Boolean suppressSecurityChecks）
at System.Reflection.RuntimeAssembly.nLoad（AssemblyName fileName，String codeBase，Evidence assemblySecurity，RuntimeAssembly locationHint，StackCrawlMark& stackMark，IntPtr pPrivHostBinder，Boolean throwOnFileNotFound，Boolean forIntrospection，
Boolean suppressSecurityChecks）
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName（AssemblyName assemblyRef，Evidence assemblySecurity，RuntimeAssembly reqAssembly，StackCrawlMark& stackMark，IntPtr pPrivHostBinder，Boolean throwOnFileNotFound，Boolean forIntrospection，
Boolean suppressSecurityChecks）
at System.Reflection.Assembly.Load（AssemblyName assemblyRef）
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectCache.LoadAssembly（String fullName）
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectCache.LoadElement（ObjectLoadInfo oli）
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetServerVersion（Urn urn，Object ci）
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetObjectInfo（Object ci，RequestObjectInfo req）
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetObjectInfo（Object connectionInfo，RequestObjectInfo requestObjectInfo）
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process（Object connectionInfo，RequestObjectInfo requestObjectInfo）
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.GetSupportedResultTypes（ISfcConnection connection，Urn urn）
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.Initialize（）
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.MarkRootAsConnected（）
at Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices..ctor（SqlConnection sqlConnection）
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.ServerHelper.ConnectToServer（String server，String username，String password，AuthenticationType authenticationType）
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.ServerProjectBrowser.validateServerWorker_DoWork（Object sender，DoWorkEventArgs e）
=========== ========================
$
参数不正确。 （HRESULT异常：0x80070057（E_INVALIDARG））（mscorlib）
----------------- -------------
节目位置：
at System.AppDomain.nApplyPolicy（AssemblyName an）
at System.AppDomain.ApplyPolicy（String assemblyName）
at Microsoft.VisualStudio.Platform.VsAppDomainManager.MatchAssemblyName（AssemblyName reference，AssemblyName definition）
at Microsoft.VisualStudio.Platform.VsAppDomainManager.FindAssembly（String name，IEnumerable`1 probingPaths）
at Microsoft.VisualStudio.Platform.VsAppDomainManager.InnerResolveHandler（String name）
at Microsoft.VisualStudio.Platform.VsAppDomainManager.ResolveHandler（Object sender，ResolveEventArgs args）
at System.AppDomain.OnAssemblyResolveEvent（RuntimeAssembly assembly，String assemblyFullName）
===================================
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)
------------------------------
Program Location:
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection,
Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection,
Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection,
Boolean suppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef)
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectCache.LoadAssembly(String fullName)
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectCache.LoadElement(ObjectLoadInfo oli)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetServerVersion(Urn urn, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetObjectInfo(Object ci, RequestObjectInfo req)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetObjectInfo(Object connectionInfo, RequestObjectInfo requestObjectInfo)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, RequestObjectInfo requestObjectInfo)
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.GetSupportedResultTypes(ISfcConnection connection, Urn urn)
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.Initialize()
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.MarkRootAsConnected()
at Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices..ctor(SqlConnection sqlConnection)
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.ServerHelper.ConnectToServer(String server, String username, String password, AuthenticationType authenticationType)
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.ServerProjectBrowser.validateServerWorker_DoWork(Object sender, DoWorkEventArgs e)
===================================
The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)
------------------------------
Program Location:
at System.AppDomain.nApplyPolicy(AssemblyName an)
at System.AppDomain.ApplyPolicy(String assemblyName)
at Microsoft.VisualStudio.Platform.VsAppDomainManager.MatchAssemblyName(AssemblyName reference, AssemblyName definition)
at Microsoft.VisualStudio.Platform.VsAppDomainManager.FindAssembly(String name, IEnumerable`1 probingPaths)
at Microsoft.VisualStudio.Platform.VsAppDomainManager.InnerResolveHandler(String name)
at Microsoft.VisualStudio.Platform.VsAppDomainManager.ResolveHandler(Object sender, ResolveEventArgs args)
at System.AppDomain.OnAssemblyResolveEvent(RuntimeAssembly assembly, String assemblyFullName)
推荐答案
具有完全相同的问题。
这篇关于在VS 2017更新15.8.0之后无法部署SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
