- There are no named instances for SSIS, check your Server Name
- You may need to open port 135
- Maybe it's sufficient SSIS server permissions
- Is the RPC service started?
- It could be a double hop authentication issue
- Is your DCOM Config for Microsoft SQL Server Integration Services configured correctly?
- Configure your firewall to allow MsDtsSrvr.exe
- Try using the IP, maybe it's netbios
As you can imagine, none of these were the solution to my problem. The root cause is that SSIS is using RPC, which has a large dynamic port range. This article describes what's going on with RPC, and has commands for identifying the existing RPC dynamic port range and how to set the range:
For example this command will show you the existing port range:
netsh int ipv4 show dynamicport tcp
For what it's worth, here are a few articles I waded through before I found the solution: