Join across different servers in SSIS is a common issue that developers face when working with multiple servers in SQL Server Integration Services (SSIS). This problem occurs when trying to perform a join operation between tables located on different servers.

The main reason for this issue is that SSIS does not natively support joining across different servers. However, there is a solution that can be implemented to overcome this limitation.

One possible solution is to use the Linked Servers feature in SQL Server. Linked Servers allow you to establish a connection between two servers, enabling you to access and query data across different servers. This feature can be utilized in SSIS to perform joins between tables on different servers.

To implement this solution, you can follow the steps outlined in the Microsoft documentation: "Joining Data from Different Servers" [1]. This documentation provides a detailed guide on how to configure and use Linked Servers in SSIS.

In summary, to join across different servers in SSIS, you can utilize the Linked Servers feature in SQL Server. This allows you to establish a connection between the servers and perform joins between tables located on different servers. By following the steps provided in the documentation, you can successfully overcome this limitation in SSIS.

[1] https://msdn.microsoft.com/en-CA/library/ms141775(v=sql.100).aspx