Begin by installing the necessary Python libraries to interact with PyPI and MSSQL. Use `pip` to install `requests` for making HTTP requests to PyPI and `pyodbc` for connecting to MSSQL.
```bash
pip install requests pyodbc
```

Use the `requests` library to access data from the PyPI API. For instance, you can retrieve metadata for a specific package using:
```python
import requests
package_name = "example-package"
response = requests.get(f"https://pypi.org/pypi/{package_name}/json")
package_data = response.json()
```

Extract and structure the required information from the fetched JSON data. Identify the fields you need, such as package name, version, author, etc.
```python
parsed_data = {
"name": package_data['info']['name'],
"version": package_data['info']['version'],
"author": package_data['info']['author'],
}
```

Configure a connection to your MSSQL database using `pyodbc`. Ensure you have the correct database credentials and have installed the ODBC Driver for SQL Server.
```python
import pyodbc
conn_str = (
"DRIVER={ODBC Driver 17 for SQL Server};"
"SERVER=your_server_name;"
"DATABASE=your_database_name;"
"UID=your_username;"
"PWD=your_password;"
)
connection = pyodbc.connect(conn_str)
cursor = connection.cursor()
```

If you haven't already, create a table in your MSSQL database to store the data. Use a SQL command to create a table with appropriate columns for your data.
```sql
CREATE TABLE PyPI_Packages (
Name NVARCHAR(100),
Version NVARCHAR(50),
Author NVARCHAR(100)
);
```

Using the database connection, insert the structured data into the MSSQL table. Prepare an SQL `INSERT` statement and execute it using the cursor.
```python
insert_query = """
INSERT INTO PyPI_Packages (Name, Version, Author)
VALUES (?, ?, ?)
"""
cursor.execute(insert_query, parsed_data['name'], parsed_data['version'], parsed_data['author'])
connection.commit()
```

After the data is inserted successfully, ensure you close the database connection to free up resources.
```python
cursor.close()
connection.close()
```
By following these steps, you can manually move data from PyPI to an MSSQL database without relying on third-party connectors or integrations.