Hi,
If you are experiencing "Testing Connectivity..." hang issue where the VS is just waiting then it is OK to kill the instance and review the packages using text editor.
In my case I had Connect Timeout = 0 and if server names were not present, the VS will never stop searching for it.
I had to open SSIS package in Textpad, search for Connect Timeout setting and change it 30(seconds) from 0.
OR
Other option would be to Work Offline.
But this option will only be set once the package open fully after Testing connectivity is done.
HTH.
If you are experiencing "Testing Connectivity..." hang issue where the VS is just waiting then it is OK to kill the instance and review the packages using text editor.
In my case I had Connect Timeout = 0 and if server names were not present, the VS will never stop searching for it.
I had to open SSIS package in Textpad, search for Connect Timeout setting and change it 30(seconds) from 0.
OR
Other option would be to Work Offline.
But this option will only be set once the package open fully after Testing connectivity is done.
HTH.
No comments:
Post a Comment