对程序包进行反序列化的异常“值不在预期范围内。 [英] Exception deserializing the package "Value does not fall within the expected range.
问题描述
Visual Studio 2015集成服务
Visual Studio 2015 Integration Services
每当我尝试执行包时，我都会收到以下错误。连接管理器看起来都很好，我可以预览我正在寻找或写入的任何数据集（Ole DB和odata）。另外我创建了一个空包并尝试执行它仍然
得到错误..所以我认为它是解决方案级别的东西。
Whenever I try to Execute a package I get the error below. The connection managers all look good and I can preview any dataset that I am sourcing or writing to (Ole DB and odata). In addition I created an empty package and tried to execute it and still got the error .. so I assume it's something at the solution level.
一些背景。我正在将许多软件包从现有解决方案转移到新的解决方案中。 （旧的解决方案和它的包工作正常）我已经将许多包组件复制到新解决方案中的新包中。我确保更新连接
经理等等。我已经确认我可以预览源数据，并且这些字段在数据类型等方面匹配。
Some background. I am moving many packages over from an existing solution into a new solution. (the old solution and it's packages work fine) I have copied over many of the package components into new packages in the new solution. I made sure to update connection managers, etc. I have already verified I can preview source data and that fields match up in data types, etc.
完全错误：
============================ =======
===================================
异常反序列化包"值不在预期范围内。"。 （Microsoft Visual Studio）
Exception deserializing the package "Value does not fall within the expected range.". (Microsoft Visual Studio)
------------------------------
计划地点：
------------------------------
Program Location:
在Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger（IVsDebugger iVsDebugger，DataTransformationsProjectConfigurationOptions选项）
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger（Int32 flags，IOutputWindow outputWindow，DataTransformationsProjectConfigurationOptions options）
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage（ProjectItem prjItem，String taskPath）
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)
====================== =============
===================================
价值不在预期范围内。 （Microsoft.SqlServer.ManagedDTS）
Value does not fall within the expected range. (Microsoft.SqlServer.ManagedDTS)
------------------------------
计划地点：
------------------------------
Program Location:
在Microsoft.SqlServer.Dts.Runtime.Interop.ProjectInterop.GetPackageByName（String bstrPackageStreamName）
在Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProject100.GetPackageByName（String bstrPackageStreamName）
在Microsoft.DataTransformationServices.Project.DebugEngine.DtsProgramNode.CreateRuntimePackageInternal（IDtsHost& host，Process& process，Package& dtsPackage）
at Microsoft.SqlServer.Dts.Runtime.Interop.ProjectInterop.GetPackageByName(String bstrPackageStreamName)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProject100.GetPackageByName(String bstrPackageStreamName)
at Microsoft.DataTransformationServices.Project.DebugEngine.DtsProgramNode.CreateRuntimePackageInternal(IDtsHost& host, Process& process, Package& dtsPackage)
推荐答案
嗨Mike，
只需打开新VS 2015中的旧解决方案。它会触发项目升级向导，可以为您使用的任何较新的SSIS版本生成新包。
just open the old solution in the new VS 2015. It'll trigger project upgrade wizard that would produce new packages for whatever newer SSIS version you use.
这篇关于对程序包进行反序列化的异常“值不在预期范围内。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
