Wes H
Reputation: 4439
SSIS/SSDT Testing Connectivity even when Work Offline is checked
I have a SSIS solution containing two projects. Both projects use parameterized project level connections, with the same connection properties.
I have checked Work Offline. Project 1 opens just fine, with the connections correctly showing as offline. Project 2 goes into a testing connectivity loop as soon as I open any package and never recovers.
If I wasn't working remote, I would just turn off the network to force offline, but that is not an option currently.
How can I bypass/exit the connectivity test, understanding that I cannot open any packages (or their properties)?
VS 2019, SSDT 3.15, connections to various database platforms and flat file, which all work in the other projects and solutions.
Upvotes: 1
Views: 684
Answers (0)
Related Questions
- The connection manager will not acquire a connection because the connection manager OfflineMode property is set to TRUE
- SSIS - Connection Manager Work Offline is grayed out
- MSTest: Ignore Intergration tests that rely on network when network is unavailable
- How to test for database availability in c# script task for an oledb connection
- Continue SSIS package when One Connection string is not reachable
- How to set connection manager offline property set False in SSIS
- the difference between DTSX "Work Offline" Connection setting and DelayValidation property?
- Should the first step of an SSIS solution be to check connections?
- SSIS Package DB Connection check
- How to test connection to a data source in SSAS using C#