Connection Manager will not receive a connection because the Connection Manager offline property is set to TRUE

When I open an 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

Meanwhile, OfflineMode is set to false. Can someone tell me why I get this error?

The DelayValidation property for the connection is set to false, and if I set it to true, the error will disappear. But I just wanted to find out why this is happening. I do not establish a connection dynamically, and the last time I used the project, there were no errors, and it was running, and DelayValidation was false. What changed?

+9
source share
10 answers

" " SSIS, .

Work Offline.

enter image description here

+15

, . " " , . , .

(. ), "", . enter image description here

+3

, , , , - .

.

  • SSIS.
  • " "
  • , .

, ... .

+1

, , SSIS, , - " ", , " ", , , - .

+1

, , "" , " " , . , True . , .

0

connectionString.

0

, . , , . ( ). .

0

, , , . , , .

0

, SQLserver ( ).. .

sqlserver,

0

, . , " " .

0

Source: https://habr.com/ru/post/1608358/


All Articles