This SSIS article shows how to transfer or copy Table data from one SQL Server Instance to Another. To demonstrate this, we transfer four tables from Task Result Database to TrasferTasks.
The below Object Explorer screenshot shows the TrasferTasks Database Tables.
SSIS Copy Table Data from one SQL Instance to Another
Double-Click on it to open the Editor. If you already have an existing connection, choose them. Otherwise, click the <New Connection> option.
Provide the Server Name and Authentication. Next, select the Source Database.
Create a new connection for the Destination Server.
Choose the Destination Database from the available list.
Select the Tables that you want to copy from one instance to another.
Select True to copy Data along with the table structure.
Run the Copy Table Data from one SQL Server Instance to Another package.