I installed microsoft updates and started getting this error. My fix in SQL Server was in SSIS connection manager under "server name" specify the port number e.g. change "AK11\PROD" to "AK11\PROD,52" if your database uses that port.

Also told it to use 32bit (since other posts say that) under Project\Properties\Debugging\Run64bitRunTime to False