connect two sql server and import to CSV file (ETL)
Welcome to the group....You can also use linked server, below link could help you

https://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server

As per the comments, adding the details from the thread mentioned

Querying across 2 different databases is a distributed query. Here is a list of some techniques plus the pros and cons:

Linked servers: Provide access to a wider variety of data sources than SQL Server replication provides

Linked servers: Connect with data sources that replication does not support or which require ad hoc access

Linked servers: Perform better than OPENDATASOURCE or OPENROWSET

OPENDATASOURCE and OPENROWSET functions: Convenient for retrieving data from data sources on an ad hoc basis. OPENROWSET has BULK facilities as well that may/may not require a format file which might be fiddly

OPENQUERY: Doesn't support variables
All are T-SQL solutions. Relatively easy to implement and set up
All are dependent on connection between source and destionation which might affect performance and scalability

Follow these steps to create a Linked Server:
1. Server Objects -> Linked Servers -> New Linked Server
2. Provide Remote Server Name.
3. Select Remote Server Type (SQL Server or Other).
4. Select Security -> Be made using this security context and provide login and password of remote server.