Begin by logging into your Retently account. Navigate to the data or report section where the information you want to export is located. Use the export functionality provided by Retently to download the data in a CSV or Excel format. Save this file to a location on your computer where it can be easily accessed.

Open the exported file in Excel or a similar spreadsheet application. Review the data to ensure it is clean and properly formatted. Remove any unnecessary columns or rows, and ensure there are no blank or malformed entries. Save the cleaned file in CSV format, which is suitable for import into MS SQL Server.

Access your MS SQL Server database using a tool like SQL Server Management Studio (SSMS). Create a new table where you will import the data. Define the table schema to match the structure of the CSV file, ensuring that data types in SQL Server align with the data types from the CSV. Execute the SQL `CREATE TABLE` statement to create the table.

Utilize the `BULK INSERT` command in SQL Server to import data from the CSV file into the newly created table. Open a new query window in SSMS and write a SQL command similar to the following:

```sql
BULK INSERT YourDatabase.YourTable
FROM 'C:\path\to\your\file.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2
);
```
Replace `YourDatabase`, `YourTable`, and the file path with your actual database name, table name, and file location.

After running the `BULK INSERT` command, check the data in the table to ensure it has been imported correctly. You can do this by executing a simple `SELECT` query to fetch a few rows from the table. Verify that the data types and values match expectations.

If there are any errors during the import process, review error messages for specific details. Common issues might include data type mismatches or incorrect file paths. Use SQL Server's error logs and messages to troubleshoot and resolve these issues. Modify data types or correct the CSV file if necessary, and then attempt the import again.

If you need to perform this data transfer regularly, consider writing a script or a stored procedure to automate the export, cleaning, and import process. You can schedule this script to run at regular intervals using SQL Server Agent or a similar scheduling tool available in your environment.

By following these steps, you can effectively move data from Retently to MS SQL Server manually, ensuring that you maintain control over the entire process without relying on third-party tools or integrations.