本文介绍了连接管理器将不会获取连接,因为连接管理器 OfflineMode 属性设置为 TRUE的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

当我在设计视图中打开现有的 SSIS 项目时,出现以下错误:

When I open my existing SSIS project in design view I get the following error:

The connection manager will not acquire a connection because the connection manager OfflineMode property is set to TRUE

同时 OfflineMode 设置为 false.谁能告诉我为什么会出现此错误?

Meanwhile the OfflineMode is set to false. Can anyone tell me why am I getting this error?

连接的 DelayValidation 属性设置为 false,如果我将其设置为 true,错误就会消失.但我只是想弄清楚为什么会发生这种情况.我没有动态设置连接,上次我使用该项目时,没有错误,它在 DelayValidation 设置为 false 时运行.发生了什么变化?

DelayValidation property of the connection is set to false and if I set it to true, the error goes away. But I just wanted to figure out why is this happening. I am not setting connection dynamically and last time I used the project, there were no errors and it ran while DelayValidation was set to false. What has changed?

推荐答案

右键单击 SSIS 设计器的连接管理器区域,然后单击.

Right-clicking on the Connection Managers area of SSIS Designer and then clicking.

这篇关于连接管理器将不会获取连接,因为连接管理器 OfflineMode 属性设置为 TRUE的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-01 19:57