Begin by selecting and preparing the data you want to move from ClickHouse. Use SQL queries to extract the necessary data, ensuring that it is filtered and formatted as needed. It's essential to keep the data types and schemas in mind to minimize issues during the transfer.

Use ClickHouse's `clickhouse-client` command-line tool to export the data to a CSV file. The command will look something like this:
```bash
clickhouse-client --query="SELECT FROM your_table" --format=CSV > data.csv
```
Ensure the CSV file is correctly formatted and includes headers if necessary.

Move the CSV file to the environment where your MS SQL Server instance is hosted. This can be done using secure copy protocols like SCP for Linux or file transfer tools for Windows.

Before importing the CSV file, create a table in MS SQL Server that matches the schema of the data you exported from ClickHouse. Use SQL Server Management Studio (SSMS) or a similar tool to define the columns and data types accurately.

Use SQL Server's BULK INSERT command to import the data from the CSV file into the newly created table. The basic syntax is:
```sql
BULK INSERT your_table
FROM 'C:\path\to\data.csv'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2 -- Use this if your CSV has headers
);
```
Adjust the path and options as needed to match your CSV file's format and location.

Once the data is imported, run a series of checks to ensure that the data integrity is maintained. This involves comparing row counts, checking for data type mismatches, and validating key columns for consistency with the original data in ClickHouse.

If this data movement is something you need to do regularly, consider automating the process. You can write a script that performs the export, transfer, and import steps, and schedule it using a task scheduler such as cron jobs on Linux or Task Scheduler on Windows.

By following these steps, you can transfer data from ClickHouse to MS SQL Server manually without relying on third-party tools.