问题描述
当我在设计视图中打开现有的 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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!