Cannot use SQLServer Destination when the SQLServer is not Local

Cannot use SQL Server as destination when the System does not have the DB Server locally.
In other words if we are trying to run SSIS remotely then use OLE DB as destination even if
The destination is SQL Server.