On Visual Studio 2010 and SSMS 2016, When giving the dynamic expression it will turn the OLEDB connection manager to offline mode and when I bring the connection manager back online it will still not work with the error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Tried making the delay validation property true, still won't work.
