SQL script to read data from one database and write to a table in another db

Could any tell me how we write SQL scripts so that we can read data from one database and write to a table in another database, since SQL scripts only allow one database connection. This can be achieved using transformations, but how can we do it in SQL script?

What is your database type?

I want to read data from sql server table and write to db2 table using a sql script.

In this case, the best option would be to use a linked server
www.sqlshack.com/how-to-create-and-confi...r-management-studio/

Please note that your question is irrelevant to our ETL software