When manually executing SSIS+ package that includes Salesforce Connection Manager component I don't get any errors. But when I execute the package via SQL Server Agent I get the following error message:
The operation has timed out.
It's possible that you have a network or a firewall issue. Please contact your system administrator about it.