SSMS = SQL Server Management Studio
SSIS = SQL Server Integration Services
SSMS is the tool you use to access SQL Server and execute queries, manage databases, tables, views, etc...
SSIS is a service that runs on a server that executes packages. SSIS packages are created using Visual Studio - specifically SSDT (SQL Server Data Tools).
If this is a one-time operation - use the Import/Export utility within SSMS. This is a wizard that builds and executes an SSIS package. If this needs to be repeatable - then you can build the package in SSDT and deploy it to an integration services catalog.
If you do not want to use SSIS - you can use Powershell. In Powershell - you would get the results into a variable using Invoke-SqlCmd - then foreach over each item in the result variable to build an insert statement - then use Invoke-SqlCmd to execute the insert statement on the destination.