SSIS 在设计器视图中运行速度极慢 [英] SSIS is running extremely slow in designer view

问题描述

首先，感谢您的时间和考虑.让我先为我的问题提供一些背景信息.

我正在开发一个包含一些数据流的 ETL 包.

其中一个有 47 个元素，如图所示:

我需要更改 Source 中的元数据，但是当错误/警告推动验证 BIDS 崩溃并变得超级慢时，无法处理任何元素.我尝试过延迟验证、元数据验证，甚至尝试使用下一篇文章/帖子中的解决方案:

删除它会消除大部分消耗 BIDS 资源的验证错误.

所以我删除了有问题的元素，然后更改了元数据，BIDS 的性能在整个编辑过程中保持最佳状态.然后我再次添加了 Union All 并连接了流.

First, thank you for your time and consideration. Let me start by providing some context to my problem.

I'm working on an ETL package which contains some data flows.

One of those have 47 elements as described in the picture:

I need to change the metadata in the Source, but when the error/warning push the validation BIDS melt down and gets super slow, imposible to work on any element. I have tried with Delay Validation, Metadata validation and even try with the solutions in the next articles/posts:

SSIS Designer is running VERY slowly

Why my BIDS is slow in design mode ?

SSIS package reacts slow in BIDS

I can't find a solution to this that doesn't imply making again the dataflow from scratch.

解决方案

After a couple of hours, asking a lot of collegues, reading a lot of posts online I realized that an enourmous amount of validation errors were comming from the Union All marked in the picture.

Delete it errased most of the validation errors that were consuming BIDS resources.

So I deleted the element in question and then I changed the metadata, BIDS's performance stayed optimal through the edition process. Then I added the Union All again and conected the flows.

这篇关于SSIS 在设计器视图中运行速度极慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！