如何修复 SSIS:“值，不在预期范围内"? [英] How to fix SSIS : "Value, does not fall within expected range"?

问题描述

当我打开包含由同事创建的 SSIS 包的解决方案时，我收到了这个尴尬的错误，它没有告诉我应该做什么来修复它.

When I open up the solution that contains SSIS packages created by a colleague, I get this awkward error that tells me nothing about what I'm supposed to do to fix it.

在打开解决方案之前，他留下了手动从 dtsx 文件中的连接字符串中取出所有变量"的说明.我已经这样做了，现在当尝试在设计器中查看包裹时，我只得到一个红色 x 的图像和这条消息.

He left instructions to take all the "variables" out of the connection string in the dtsx file manually before opening up the solution. I have done that, now when try to view the package in the designer I just get an image of a red x and this message.

您看不到任何设计元素，顶部没有用于切换到错误或数据流的选项卡.屏幕上只有一个灰色的中心区域，带有红色的 x，以及消息，就像 VisualStudio 在读取 dtsx 文件的过程中死掉一样.

You cannot see any design elements, no tabs across the top to switch to errors or data flows. Just a gray center area on the screen with a red x, and the message, its like VisualStudio dies in the process of reading the dtsx file.

推荐答案

这个问题相当不具体，所以在这里当然很难走上正轨.所有给出的答案都关注不同的问题.我会说 PeterX 有最好的猜测.错误的原因可能很简单，比如修改了数据源.

The question is rather unspecific so it’s of course difficult to get on the right track here. All of the given answers focus different issues. I would say that PeterX had the best guess. The reason for the error could be as simple as a modified data source.

在向需要由现有 SSIS 包处理的表中添加新列时，我经常遇到错误错误输出没有相应的输出".此错误伴随着一条错误消息，指出值不在预期范围内".

I came across with a bug "error output has no corresponding output" quite often when adding a new column to a table that needs to be processed by an existing SSIS package. This bug came along with an error message saying that a "Value does not fall within the expected range".

新添加的列需要由现有 SSIS 包处理.预期的行为是 SSIS 将识别出有一个新列并在要处理的 OLEDB 源任务 SSIS 的列页面上选择此列.但是，在修改表后第一次打开 OLEDB 源任务时，我收到两次以下错误消息:值不在预期范围内."打开编辑器和打开编辑器的列"页面时显示错误消息.在 OLEDB 源任务的高级编辑器中，新列出现在 OLEDB 源输出列树中，但未出现在 OLEDB 源错误输出列树中.这是错误消息的实际潜在问题.不幸的是，似乎没有办法手动添加缺失的列.

A newly added column needed to be processed by an existing SSIS Package. The expected behavior is that SSIS will recognize that there is a new column and select this column on the columns page of the OLEDB Source Task SSIS to be processed. However, when opening the OLEDB Source Task for the first time after having modified the table I got twice the following error message: "Value does not fall within the expected range." The error message showed up when opening the editor and when opening the Columns page of the editor. Within the Advanced Editor of the OLEDB Source Task the new column showed up in the OLEDB Source Output Columns Tree, but not in the OLEDB Source Error Output Columns Tree. This is the actual underlying problem of the error message. Unfortunately, there seems to be no way to add the missing column manually.

为了解决这个问题，如Jeff提到的那样，在普通编辑器的Columns Page中删除并重新添加新添加的列.

To solve the problem, remove and re-add the newly added column on the Columns Page of the normal Editor as mentioned by Jeff.

值得一提的是OLEDB Source任务的数据源是一个修改后的MDS View.Microsoft CRM Dynamics - 正如相关主题中提到的 - 也在使用视图.这使我得出结论，在修改数据类型或添加/删除列时，使用视图作为数据源可能会产生上述任一错误.

It is worth to be mentioned that the data source of the OLEDB Source task was a modified MDS View. Microsoft CRM Dynamics – as mentioned in the related thread – is using views, too. That leads me to the conclusion, that using views as a data source may produce either of the above mentioned errors, when modifying datatypes or adding/removing columns.

相关主题:错误"...非错误输出上的OLE DB Source.Outputs[OLE DB Source Output].Columns[XXXXXXXX]没有对应的输出

所描述的解决方法是指带有 Mircorsoft.NET Framework 3.5 SP1 的 Visual Studio 2008 版本 9.0.30729.4462 QFE.数据库为 SQL Server 2008 R2 (SP2).

The described workaround refers to Visual Studio 2008 Version 9.0.30729.4462 QFE with Mircorsoft.NET Framework 3.5 SP1. The database is SQL Server 2008 R2 (SP2).

这篇关于如何修复 SSIS:“值，不在预期范围内"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！