在 VS 设计器中加载包时禁用 SSIS 包验证 [英] Disabling SSIS Package Validation when Loading a Package in the VS Designer
问题描述
我有一些 SSIS 包部署到 SQL 2005 服务器，随后在 Visual Studio 2003 中设计和维护.当我打开任何 BIDS 项目，然后打开其中一个包时，设计器总是验证每个数据流和任务对象.
I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the packages, the designer always validates every Data Flow and Task object.
通常，这不是问题.但是，在某些情况下，我们用于从 AS400 连接和导出数据的系统帐户将无法正确验证.由于我要导出一吨表，每个数据流对象都尝试通过 ODBC 连接连接到 AS400，它会收到无效帐户"错误，然后继续尝试验证下一个任务.这会锁定系统帐户，因为无效凭据已尝试 40 多次.
Usually, this isn't a problem. However, under certain circumstances a system account that we use for connecting and export data from an AS400 will not validate properly. Since I'm exporting a TON of tables, each Data Flow object attempts to connect to the AS400 through an ODBC connection, it gets an "Invalid Account" error, and then proceeds to attempt validation of the next task. This locks the system account because the invalid credentials are tried 40+ times.
在我尝试运行包之前，我可以做些什么来禁用验证?作为替代方案，是否有我可以切换的设置，一旦发现一个无效对象就会停止所有验证?AS400 系统将允许在锁定帐户之前进行一些错误的尝试.显然，如果我能在验证过程发生之前切断验证过程，那将是最佳选择.
Is there something that I can do to disable validation until I try to run the package? As an alternative, is there a setting I can toggle that will stop all validation as soon one invalid object is found? The AS400 system will allow a few mistaken attempts before locking the account. Obviously, it would be optimal if I could cut off the validation process before that takes place.
我有哪些选择?
推荐答案
抱歉含糊不清，复制/粘贴太长了
Sorry to be vague, but this is too long to copy/paste
这里描述了这 3 个影响加载速度 + 验证的选项
This describes these 3 options which affect loading speed + the validation
- DelayValidation 属性
- ValidateExternalMetadata 属性
- 离线工作"选项(SSIS 菜单 -> 离线工作以启用/禁用它)
您也可以在每个连接/任务的其他几个地方延迟验证"
You can also "DelayValidation" to in several other places too per connection/task
这篇关于在 VS 设计器中加载包时禁用 SSIS 包验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
