连接管理器将不会获取连接，因为连接管理器 OfflineMode 属性设置为 TRUE [英] The connection manager will not acquire a connection because the connection manager OfflineMode property is set to 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！