I had a similar issue with "login timeout expired" because we do not have any default instances on our servers. I had to edit the ssis ini file and put in the ServerName\InstanceName name instead of the default .
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ MsDtsSrvr.ini.xml