If tMSSqlOutput uses the existing connection from the tMSSqlConnection component, it will not create anything in SQL. However, if it does not use the existing connection and builds from the same repository as tMSSqlConnection, tMSSqlOutput works as intended and creates the SQL Table upon execution. Additionally, it does not throw any errors during the run, but fails to create/insert any tables/data.
With an existing connection selected:
Without an existing connection:
Verify that Auto Commit is selected under Advanced Settings of the tMSSqlConnection, or you can add a tMSSqlCommit component.