Notifications
Clear all
Topic starter
06/05/2022 3:17 pm
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
------------------------------
Topic starter
06/05/2022 3:50 pm
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.
