Notifications
Clear all

[Solved] connection manager 'DATAMART' is working offline

 

Joined: 3 months ago
Posts: 6
Topic starter  

TITLE: Microsoft Visual Studio
------------------------------

Could not retrieve the table information for the connection manager 'DATAMART'.
Failed to connect to the source because the connection manager 'DATAMART' is working offline.

OK
------------------------------


Quote
Joined: 3 months ago
Posts: 6
Topic starter  

Whenever connection manager could not connect to database, your connection status for that particular connection will change to offline.

Maybe you lost the internet connection, forgot to check the "save password" checkbox, or what ever.

 

To solve the problem, 

- right click on the connection and uncheck Work Offline or

- Menu -- SSIS -- Check Work Offline. Then uncheck Work Offline.

That should fix the problem. 

 


ReplyQuote
Share: