How to get rid of TESTING CONNECTIVITY at the time of Opening SSIS packages in SSDT

Posted by on Jan 9, 2013 in SQL Server, SSDT, SSIS | No Comments
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

SSDT has an option to test connectivity of connection managers at the time of opening the SSIS package. You can change this behaviour with WORK OFFLINE option.

When you have many connection managers in SSIS package, you may face a halt at the time of opening each package with a “testing connectivity” message. This will be annoying when connection managers connected to servers that respond slowly or not available at the moment. And as a result you may wait for minutes to finishing that testing connectivity. This behaviour can be changed simply.

At the time of opening SSIS packages in SSDT you may see the “testing connectivity” message at the bottom of SSDT and a halt in designer. This will test connectivity for all connection managers that don’t set their work offline option.

Testing Connectivity in SSIS packages happens to check each connection manager status and show the small icon for connect or disconnecting the connection.

So you can get rid of that testing connectivity step with one of these methods:

Each connection manager has an option for working offline, and you will see it when you right click on the connection manager as a Work Offline menu option. And that option will get rid of testing connectivity for that specific connection manager.

If you have many connections and many packages then it will be hard to change this configuration for all of them. But don’t worry, there is a simpler way to do it at SSDT level;

There is a Work Offline option for the whole SSDT. You can find this option when you right click on a package designer area in the menu

With checking the WORK OFFLINE option in SSDT, all packages and connections will obey this setting and don’t check connectivity for connection managers. So with this setting you will not see icons showing connection manager connectivity status on each connection manager in designer pane, but on the other hand package will open faster and you don’t need to wait too long for testing connectivity of slow connections.

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leave a Reply

Your email address will not be published. Required fields are marked *