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

Question

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

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

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?

Answer 1

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

or

Answer 2

This didn't work for me because I was using a connection string expressions. Clearing the 'work offline' check would temporarily appear to work, but then it would suddenly recheck. This was frustrating to say the least.

Once I edited the connection string to place the provider in the correct place (see image for what worked for me) then it stopped toggling the 'offline' mode on because it could connect to the DB.

Answer 3

Please create a variable for data source of the connection manager and apply to the connectionString Expression.